Showing totals in data table in a line chart

  • Thread starter Thread starter burke8190
  • Start date Start date
B

burke8190

I'm trying to show the totals of two data series in a line chart. Everytime I
inlude the cells in the data range the total cells are plotted in on the
chart. Is there a way to dispaly the sum of the cells and not plot the totals
on the chart?

Bill
 
Hi,

How do you want to display the total?

1. Don't include the totals in the range you select to plot, then add a
textbox and enter the total. To make the textbox dynamic - select the chart
area and type = and click on the cell where the total is. Press Enter. Move
the textbox whereever you want it.
 
Awesome, thanks for your help Shane

Shane Devenshire said:
Hi,

How do you want to display the total?

1. Don't include the totals in the range you select to plot, then add a
textbox and enter the total. To make the textbox dynamic - select the chart
area and type = and click on the cell where the total is. Press Enter. Move
the textbox whereever you want it.


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire
Click to expand...
 
Back
Top