The data table won't display totals. However, you could show the totals
with the X axis label:

In the data source table, insert a row between the X Axis labels, and
the first row of data.
In the cell below the first label, enter a formula that refers to the
cell with the label, and the cell with the total, e.g.:

=B1 & CHAR(10) & B8

Copy this formula across to the last column of data.

Select the chart
Choose ChartSource Data
On the Series tab, for Category (X) axis labels, select the cells that
contain the above formula
Click OK

Mike wrote:
How do I display totals within the graph data table without those figures
showing up in the graph


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html