Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot graph
How do you get the grand total column from the pivot table graphed on the pivot graph??? -- cutsygurl ------------------------------------------------------------------------ cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041 View this thread: http://www.excelforum.com/showthread...hreadid=475577 |
#2
|
|||
|
|||
Hello Cutsygurl,
I do not know a way to include the grand total as a cloumn in a PivotChart. You could create a normal chart, based on the pivot table, and include your grand total in this normal chart. 1. Select an empty cell away from the Pivot Table. 2. Click the Chart Wizard button. 3. Click Finish, to create an empty chart. 4. Select cells in the Pivot Table, and drag them to the blank chart. Take care not to select a cell which contains a Pivot Table button, or the chart will become a Pivot Chart. One of the MVP's may have a better solution. Cheers, Annie Note: If you select a cell which contains a Pivot Table button, the chart will become a Pivot Chart. "cutsygurl" wrote: How do you get the grand total column from the pivot table graphed on the pivot graph??? -- cutsygurl ------------------------------------------------------------------------ cutsygurl's Profile: http://www.excelforum.com/member.php...o&userid=15041 View this thread: http://www.excelforum.com/showthread...hreadid=475577 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Graph with pivot table | Excel Discussion (Misc queries) | |||
Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) | |||
How to increase the size of a Pivot Table Graph | Excel Discussion (Misc queries) | |||
Changing Graph Title W/ Pivot | Excel Discussion (Misc queries) |