How do I use data from 2 separate worksheets in one chart?

  • Thread starter Thread starter Skeety
  • Start date Start date
Hi,

What version of Excel are you using:

In 2003 and earlier in the Chart Wizard in the Data range box on step 2,
highlight one of the ranges, then hold down the Ctrl key and highlight the
other range.
 
Both ranges highlighted in this way must be on the same worksheet.

You can use data from different sheets in the same chart, but the X values
or Y values within a single series cannot be split over multiple worksheets.
You could construct a summary table linking to the separate sheets. This
page gives more details:

- Jon
 
Hi Skeety,

If the data is on different sheets you can use the Series tab of the 2nd
step of the Chart Wizard to specify each of the ranges one at a time. These
ranges can even be in different workbooks.

I didn't check out the site Jon recommended yet.
 
Thanks Shane - my chart looks lovely now!

ShaneDevenshire said:
Hi Skeety,

If the data is on different sheets you can use the Series tab of the 2nd
step of the Chart Wizard to specify each of the ranges one at a time. These
ranges can even be in different workbooks.

I didn't check out the site Jon recommended yet.
Click to expand...
 
Hi Jon, thanks for the info, I now have a highly informative chart to share
with my colleagues!
 
Back
Top