Thread: How do I use data from 2 separate worksheets in one chart?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
ShaneDevenshire ShaneDevenshire is offline
external usenet poster
  
Posts: 2,344
Default How do I use data from 2 separate worksheets in one chart?
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.
--
Cheers,
Shane Devenshire


"Skeety" wrote:

Both worksheets are in the same workbook.
Reply With QuoteReply With Quote