| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
pivotchart
How do I show the subtotals and grand totals calculated by the pivot table in
a pivot chart? |
|
#2
|
|||
|
|||
|
I don't know of a way to include the totals in a PivotChart. You could
create a normal chart, based on the pivot table, and include the totals in that. On Jon Peltier's site, there are instructions for creating a normal chart from pivot data: http://www.peltiertech.com/Excel/Pivots/pivotcharts.htm Shin wrote: How do I show the subtotals and grand totals calculated by the pivot table in a pivot chart? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotChart, How to show Grand Totals in the chart? | Charts and Charting in Excel | |||
| Pivotchart Multiple series question | Charts and Charting in Excel | |||
| PivotChart Data Field - can it be value? | Charts and Charting in Excel | |||
| How do I change how PivotChart data is summarized, from sum to av. | Excel Worksheet Functions | |||
| PivotChart: how to make it dynamic? | Charts and Charting in Excel | |||
Linear Mode
