Posted by Cathy Moody on February 04, 2002 8:37 AM
I am trying to put a Grand Total row in a chart data section. When I select the area for grand totals from the pivot table and insert it into the chart, the totals are included in the chart figures. I want them independent of the chart and only dependent on the column cells above as a sum. I am having to draw text boxes under each column and type in the totals, is it possible to have row that is not figured into the chart data, and if so how is it done?