How to plot Total Row from Table

[BasinCruiser]

I have a set of data in formatted as a Table (Table1). I have added at the bottom of the Table the Table Style Option: Total Row, and for each data Series, have the Sum selected, to add up the Total for each data series.

Problem: I can't plot the data from this Total Row. Whenever I try to include this Totals Row in the data range for a chart, it cuts off the Total row. If I try to capture just the Total Row, it leaves the chart blank. How can I include in a Chart the Totals Row from a Table?

The only alternative solution I have is to create a 2nd set of data, including the Titles of each of my Series from Table1, then calculate the sum of all of these series. Then, I can create a chart from this data.

Table with Column Row Totals.xlsx

This seems a bit redundant to have to create a 2nd set of data that is the exact same data that is already in the Total Row of the original Table1. How can you skip this extra step, and just chart the data from this Total Row?

Thanks.

[BasinCruiser]

Oh. I forgot to add: I am using Excel 2007.

[cbatrody]

Hi,

I have linked the second chart to the Total Row in the table in the attached file. Please see if this is what you are looking for.





Please click on ‘ * Add Reputation’ if I was helpful in resolving the issue.

[BasinCruiser]

Hi,

I have linked the second chart to the Total Row in the table in the attached file. Please see if this is what you are looking for.





Please click on ‘ * Add Reputation’ if I was helpful in resolving the issue.

Thank you for you help.

I can see that the Chart Data Range contains the Series Titles and Total rows, but there are no Legend Entries (Series) nor Horizontal (Category) Axis Labels, resulting in a blank chart. Capture.PNG

I was trying to do exactly what you did, and would only get the same result as you.

[cbatrody]

Hi,

The graph has X & Y Axis labels in the file I had attached. It was a bar chart with Series numbers added as bars.

[BasinCruiser]

Hi,

The graph has X & Y Axis labels in the file I had attached. It was a bar chart with Series numbers added as bars.

So, when you look at that file that you attached, you see the the bar chart? When I look at that file, I see a blank chart. Is there something setup wrong in my Excel settings? I've looked through all of the settings and can't find anything that I can think would cause this.