Create pivot charts

Excel for 365 Excel for 365 for Mac Excel for the web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel năm nhâm thìn Excel năm nhâm thìn for Mac Excel 2013 Excel 2010 Excel 2007 More...Less

Sometimes it"s hard to lớn see the big picture when your raw data hasn’t been summarized. Your first instinct may be to create a PivotTable, but not everyone can look at numbers in a table và quickly see what"s going on. PivotCharts are a great way to lớn add data visualizations khổng lồ your data.

Bạn đang xem: Create pivot charts

Household expense data

Corresponding PivotChart




Create a PivotChart

Select a cell in your table.

Select Insert > PivotChart .

Select OK.

Create a chart from a PivotTable

Select a cell in your table.

Select PivotTable Tools > Analyze > PivotChart .

Select a chart.

Select OK.

Xem thêm: License Key Avast Internet Security Key 2019 + 25 License Keys 2019 2021

To create a PivotChart on the Mac, you need to create a PivotTable first, & then insert a chart. Once that is done, the chart will behave sầu like a PivotChart if you change the fields in the PivotTable Fields danh mục. 

Select any cell within the PivotTable.

On the Insert tab, cliông xã a button khổng lồ insert either a column, line, pie, or radar chart. Please note that other types of charts vị not work with PivotTables at this time. For example, treebản đồ charts, statistical charts, và full bộ charts vì chưng not work with PivotTables yet.

To create a PivotChart in Excel for the web, you will first need to create a PivotTable. To bởi that, see Create a PivotTable lớn analyze worksheet data.

Select a cell in your PivotTable.

On the Insert tab, select the Insert Chart dropdown menu, and then cliông chồng any chart option.

The chart will now appear in the worksheet. When you cliông chồng anywhere in the chart, the Chart tab appears in the ribbon. You can use any of the options in the Chart tab lớn modify the chart.

See Also

Add axis titles lớn a chart

Change axis labels in a chart

Need more help?

You can always ask an expert in the Excel Tech Community or get tư vấn in the Answers community.

See Also

Create a PivotTable

Use the Field List to lớn arrange fields in a PivotTable

Use slicers khổng lồ filter data

Create a PivotTable timeline to filter dates


Need more help?

Expand your skills
Explore Training
Get new features first
Join Insiders

Was this information helpful?

Thank you! Any more feedback? (The more you tell us the more we can help.)Can you help us improve? (The more you tell us the more we can help.)
What affected your experience?
Resolved my issue
Clear instructions
Easy to follow
No jargon
Pictures helped
Didn't match my screen
Incorrect instructions
Too technical
Not enough information
Not enough pictures
Any additional feedback? (Optional)
Submit feedback

Thank you for your feedback!

What's new Store
English (United States) © 2021