Charting continious data across sheets.

[Steve]

How do you chart data from three sheets within the smae
work book on the same series on the same chart? it seems
to want to create a new series unstead of charting year 1-
3on the one series.

Thanks,

 

[Don Guillett]

See this from an earlier post by Jon
http://peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html

 

[Tushar Mehta]

You cannot have the x (or y) component of one series contain data from
multiple sheets. One option is to put all the data together on a
single sheet. Another option that will work for certain types of
charts is to create two series but through appropriate formatting make
it look like one series.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions