| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Charts
Hello
I have created a pivot chart from a pivot table. The chart is showing the data but does not show the Grand Total at the end of the chart. If draw a 'normal' chart it will show the Grand Total if you select it. Is it possible to do it on the Pivot Table Thanks in advance James |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Pivot Charts
I don't know of any way to include the grand total in a PivotChart. You
can 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 James L wrote: Hello, I have created a pivot chart from a pivot table. The chart is showing the data but does not show the Grand Total at the end of the chart. If draw a 'normal' chart it will show the Grand Total if you select it. Is it possible to do it on the Pivot Table? -- 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 | |||
| Pivot Tables & Pivot Charts | Charts and Charting in Excel | |||
| Combing Pivot and Non-Pivot datasets for 2-axis charts. | Charts and Charting in Excel | |||
| Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
| How do I create multiple pivot charts from one pivot table? | Charts and Charting in Excel | |||
| Can links between Excel 2003 Pivot Charts and their pivot table b. | Charts and Charting in Excel | |||
Hybrid Mode
