Summing trendlines in excel charts?

S

simonpitt

Hi Guys

Is it possible to sum trendlines, or simply series, in excel charts?

I have a large spreadsheet recording financial expenditure in respect
of about 10 different job numbers, with each of these graphed on the
chart showing trend lines. The problem is, if you simply chart the data
in aggregate in order to find an overall trend line for expenditure,
ie. set the source data to the various columns under each job number,
there are large numbers of transactions under different job numbers on
the same date, which means that these transactions aren't summed but
appear as different points on the chart, resulting in an incorrect
trendline. So is there some sort of function to add together trendlines
or series in charts, or alternatively, is there another way of
achieving the same outcome: an overall trend line for multiples series?
Thanks for your help,

Cheers

Simon
 
J

Jon Peltier

Simon -

Couldn't you plot all the data together? I guess you'd have to add up all the values
for each date.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Top