View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Skeety Skeety is offline
external usenet poster
 
Posts: 4
Default How do I use data from 2 separate worksheets in one chart?

Thanks Shane - my chart looks lovely now!

"ShaneDevenshire" wrote:

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 Devenshire


"Skeety" wrote:

Both worksheets are in the same workbook.