Multiple sheet line-chart problem

[dimitar]

Hi all,

Does anyone know if it is possible to create a linechart with a series that pulls data from two different sheets?

For e.g. Feb 2014 - Jan 2015 where the 2014 data is in one sheet and the 2015 data in another sheet?

I tried to combine them but Excel 2007 throws an error if you try to put data from two different sheets in one series.

Thanks for the help in advance,

Greets,
Dimitar Zhelyazkov

 

[Luke M]

You can have 2 different series that each pull from different sheets, but no, one series must pull from one single sheet.

However, in your case, I'd strongly recommend using an extra worksheet with formulas that pulls all the desired information into a single, nicely organized location, and then build the chart from that.