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.
|