Excel Charting across Worksheets

[Monte Sliger]

Hi,

I am trying to create a simple line chart using the same cell (C3 in this
case) on four contiguous worksheets (Sheet1 through Sheet4) as my 4 data
points. I have tried generating the chart using the chart wizard and
setting Cell C3 on Sheet 1 as my data series. I then tried modifying that
first data point (listed in the data series as 'Sheet1'!$C$3) to read
'Sheet1:Sheet4'!$C$3 (sort of like summing the same cell on different
worksheets) but this gives me an error.

If any one can show me how to do this either by giving me steps to follow
while using the chart wizard to set up the chart or modifying the reference
after the chart is set up I would appreciate it. Even if this cannot be
done, knowing that would stop me banging my head against a wall.

Thanks for any assistance you can give me.


Monte Sliger

 

[Debra Dalgleish]

Jon Peltier has instructions for charting data from different sheets:


http://www.peltiertech.com/Excel/ChartsHowTo/ChartDataFromDifferentSheets.html