D Dee Member Dec 15, 2011 #1 I need to add Grand total to pivot chart. Grand total column is appearing in pivot table but it is not considered in the pivot chart. Can you guys help me in showing GRAND Total in the Pivot chart? Thanking you in advance, Dee
I need to add Grand total to pivot chart. Grand total column is appearing in pivot table but it is not considered in the pivot chart. Can you guys help me in showing GRAND Total in the Pivot chart? Thanking you in advance, Dee
S Sachin New Member Dec 15, 2011 #2 As far as I know you can't. I tried it several years ago, couldn't get it to work and since gave up. This was in 2007. Perhaps 2010 is different.
As far as I know you can't. I tried it several years ago, couldn't get it to work and since gave up. This was in 2007. Perhaps 2010 is different.
N NARAYANK991 Excel Ninja Dec 17, 2011 #3 Hi , Googling this provides several links , some of which say it cannot be done , and some which tell you how to do it ! 1. http://www.ehow.com/how_5992410_include-totals-excel-pivot-charts.html 2. http://www.mrexcel.com/forum/showthread.php?t=494563 3. http://www.excelforum.com/excel-charting/479181-how-do-i-show-the-grand-total-on-a-pivot-chart.html Narayan
Hi , Googling this provides several links , some of which say it cannot be done , and some which tell you how to do it ! 1. http://www.ehow.com/how_5992410_include-totals-excel-pivot-charts.html 2. http://www.mrexcel.com/forum/showthread.php?t=494563 3. http://www.excelforum.com/excel-charting/479181-how-do-i-show-the-grand-total-on-a-pivot-chart.html Narayan
