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

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/
_______

wrote:

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