Formatting a Pivot Table Chart in Excel

Question

How to format a PivotTable Chart in Excel?

Answer

Under the Design tab, you have the option to add titles, axes and gridlines using the Add Chart Element tool.  To add a Chart Title go to the Chart Layouts tab and go to the Add Chart Element tab.  Here you have the option of adding a chart title.  

Under the Format tab there are numerous options to format the PivotTable Chart.

                                                                                               
To change the text on the Pivot Table Chart go to the Format tab and go within the WordArt Styles and you can change the color and style of the text as well as add outlines to the text in the chart.

                                                        
In a Pivot Table chart, you also have the option to insert a slicer.  Go to the Pivot Chart Tools tab and click on the Analyze  tab.  Observe the Insert Slicer icon and select insert slicer. Select the field name you would like to add as a slicer and click OK. 

For more information about Pivot Tables in Excel, please view the full tutorial from the CTL here: Excel Part 4

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7987
Created
Fri 12/30/22 2:05 PM
Modified
Fri 11/3/23 4:12 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.