If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Chart / Table
Hi all
I have a pivot table showing various figures with a grand total column at the right hand side, automatically generated by selecting grand totals for columns under pivot table options. The various figures are displayed on a pivot chart as lines over time but i want to include the grand total column on the same chart as well, but cannot find any options for doing this. It does not appear as an option anywhere. If anyone can help it would be much appreicated. Bilbo |
#2
|
|||
|
|||
Pivot Chart / Table
I don't know of any 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 Bilbo Baggins wrote: I have a pivot table showing various figures with a grand total column at the right hand side, automatically generated by selecting grand totals for columns under pivot table options. The various figures are displayed on a pivot chart as lines over time but i want to include the grand total column on the same chart as well, but cannot find any options for doing this. It does not appear as an option anywhere. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|