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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Doughnut Chart linked with the slicer in the pivot table 0
Creating a Chart on form from selected data in query. 0
Charts with multiple kinds of data? 0
How to getting text labels to show up in scatter chart. 0
Leader Lines In Pie Charts Not Displaying 0
Problem with Excel/PowerPoint interface when creating charts 2
Cumulative formula for word table 0

Top