creating chart from different sheet

  • Thread starter Thread starter test
  • Start date Start date
T

test

Hi

Looking for the method to create chart in Excel sourcing cell from
different sheets, instead of same sheet.. I already tried hold CTrl key
but it gives the format error when i try to add series to the chart if
the data is from the two different sheets.
 
All the data for the values for one axis for a series on a chart must
be on a single worksheet. So, all the x-values for a series must be on
a worksheet, just as all the y-values must be on a single worksheet.
Other than that, there are no restrictions as to the source worksheet.
So, a series could have x-values from Sheet1, and the y-values from
Sheet2. In addition, another series on the same chart could have data
from Sheet3 (x-values) and Sheet4 (y-values).

Of course, the chart title could come from yet another sheet, etc.

--
Regards,

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