Editing Data Table Linked to Chart

[ken923a]

I have built a chart and am displaying the data table that is associated with that chart automatically.

I would like to show the Totals for each column in the data table, but not show them graphed. Obviously that distorts the graph. Is there a way to manipulate that linked data table to show info, but not show the same cells on the graph? I've tried alot from the camera tool and everything but am at a lost.

Thanks all!

Ken

 

[TFCJamieFay]

Hi and welcome to the board!

If you create your graph with the totals showing on the graph, then on the Totals series in the graph, right click and select "Format Data Series" the chage the Border to "None" and change the Area to "None". This should hide the Totals series on the graph but still include it on the data table.

HTH,

Jay