Pivot Table Chart Question
Hi
I run Win2K with Excel 2K I have a pivot table that I run a chart from. The chart works fine, however it does not display the "grand total" from the pivot table. Is there a way that the grand total from the pivot table can be displayed on the chart? Thanks John |
Pivot Table Chart Question
Pivot charts aren't very flexible, and lack many of the standard options of
regular charts. A pivot chart only shows data from the pivot table (you can't add other data), and it shows all data from the pivot table (you can't exclude any), except as you've discovered, totals and subtotals. You could make a regular chart from this pivot table's data: http://pubs.logicalexpressions.com/P...cle.asp?ID=553 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "John Calder" wrote in message ... Hi I run Win2K with Excel 2K I have a pivot table that I run a chart from. The chart works fine, however it does not display the "grand total" from the pivot table. Is there a way that the grand total from the pivot table can be displayed on the chart? Thanks John |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com