Thread: create chart with data from across seperate worksheets

i am currently trying to create a line chart using data found in different
worksheets, but in the same workbook. although i can carry this out by
cutting and pasting all the required data into the same worksheet whenever i
try to pick the data from several or even two sheets i get a error message.
i would've thought i'd be able to pick this up seperately...as you can for
any other formula.

Hi,

See Jon's page for information.
http://peltiertech.com/Excel/ChartsH...iffSheets.html

Cheers
Andy

Diz wrote:
> i am currently trying to create a line chart using data found in different
> worksheets, but in the same workbook. although i can carry this out by
> cutting and pasting all the required data into the same worksheet whenever i
> try to pick the data from several or even two sheets i get a error message.
> i would've thought i'd be able to pick this up seperately...as you can for
> any other formula.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info