Another question on plotting a bar chart from a pivot table

[Jerome Ranch]

So I want to plot a bar chart from a pivot.
I have several x-axis values (categories), and this with be a
side-by-side bar chart as I have 2 different y axis values for two
experimental treatments. But there is a value across the treatments
at each category (i.e.the row total). How do I tell Excel to plot the
column categories as well as the column total? Righ now it won't plot
the total as a separate bar for each category.
Thanks
Jerry

 

[Debra Dalgleish]

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

 

[Jerome Ranch]

That I know how to do, thanks Debra
Jerry