Adding a total row to a chart data table

[John Ortt]

I have the following data in a chart

Week 1 2 3 4 5 6 7 8
Data1 1 5 7 6 1 6 7 6
Data2 3 4 5 7 9 4 6 6

Is it possible to have the data table show a totals row?

I.E:

Totals 4 9 12 13 10 10 13 12

Thanks in advance,

John

 

[Debra Dalgleish]

You can't include the total in the data table. As a workaround, you
could embed the chart on a worksheet, and display the data below it.
Tushar Mehta has instructions on his web site:

http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

 

[John Ortt]

You can't include the total in the data table. As a workaround, you
could embed the chart on a worksheet, and display the data below it.
Tushar Mehta has instructions on his web site:

http://tushar-mehta.com/excel/newsgroups/data_table/index.htm

Thanks Debra,

I'll give it a try.