Show total row in Data Table

M

MJP

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) I am using Charts in my power point, and I'd like to have the associated Data Table display the totals.

For example, I'm using a line chart, which shows data across months. I have selected to show the Data Table at the bottom of the chart, but I can't seem to display a Total Row - is this possible?

If I add a total row to the excel data behind the chart, then it seems to add it in as new data and add those numbers to my original data, which is not correct.

Thanks for any help!
 
C

CyberTaz

AFAIK that cannot be done simply because the totals are not a part of the
data being plotted, therefore they are not a part of the "Data Table".

What you might consider doing is not including the Data Table. Instead, copy
the data range including the Totals then paste that in as a separate object.
 
Top