 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-25-2005, 02:05 PM
|
|||
|
|||
|
How do I show the Grand Total on a Pivot Chart?
I am creating Pivot Tables in Excel and at the bottom of the pivot table, it
will show the total for each column. When I create a Pivot Chart, these values are lost. I would like to show them somewhere on the pivot chart. 
|
|
#2
10-26-2005, 01:05 AM
|
|||
|
|||
|
Re: How do I show the Grand Total on a Pivot Chart?
You can't include the Grand Total in a pivot chart. 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 Scott_F wrote: > I am creating Pivot Tables in Excel and at the bottom of the pivot table, it > will show the total for each column. When I create a Pivot Chart, these > values are lost. I would like to show them somewhere on the pivot chart. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
