May 4 2012, 11:34 AM
I have a stacked bar chart linked to a pivot table. I would like to have the total of each stacked bar shown at the top of the column. I thought, if I could add a series to the chart as a scatter graph, then use the Grand Total values as the labels this would get me what I want. I can't seem to be able to add a new series.
May 9 2012, 02:35 PM
I find that charts that are created directly from a pivot table are excellent for what they do. However they don't allow for much adlibbing. If you need to customize a chart based on a pivot table, make named ranges out of what you need to plot and then set up the graphs to reference these named ranges.
You'll need a good understanding of the OFFSET formula. Good luck!