Showing totals in data table in a line chart

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
 
S

Shane Devenshire

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.
 
B

burke8190

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...
 

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

How to add colum totals to a pivot chart data table 1
Not plot a data series in a chart but still display in data table 1
Surpressing plot of blank cells 3
Different data series in table than in the line chart 1
Including Totals in Chart's data table 1
Pivot Table Chart - Group Totals 1
Showing Totals in a Data Table on a 100% Stacked Chart? 1
Line Chart & Bar Chart Combined 2

Top