Charting continious data across sheets.

  • Thread starter Thread starter Steve
  • Start date Start date
S

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,
 
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
 
Back
Top