multiple sheets

[Marty]

Friends
I want to produce a simple line chart. The data I want on this chart is
located in the same cell range but on a number of worksheets. Example sheet1
A 17, sheet 2 A17 sheet 3 A17 ect. How do I add this data to form one chart?
I am looking to see a moving scale of the data in A17.
My aim is to keep adding new data to a new work sheet in the same work book
and have this constant A17 updating my chart.

 

[FloMM2]

Marty,
An easy way to do this is:
Build Chart using sheet1 A17
When the chart looks like you want it.

Select the chart, it will have a box around the whole chart.
Right-mouse-click and select "Data Source"
Select the tab "Series"
Add a series, in the Name: box Left-mouse-click to select it.
Then just select the cell you would like to add sheet2 A17.

hth
Dennis

 

[Marty]

Thanks I have tried that before.
The result I want is to get is one series with added data that is contained
on other spreadsheets.
How you have suggested adds another line (series) to the chart, this is not
how I want to display my result. I am after on continue line always updating.

 

[FloMM2]

Marty,
I selected "Bar" chart.
Select the second Bar chart in top row.
Series tab, select A17 on sheet1.
Add series, "Value:" type "=Sheet2!$A$17"
Reat add series for each sheet in workbook.
It will stack each series in one column.

I tried it as a line, it does not look good.
Just one point above the next series, no line.

hth
Dennis

 

[Jon Peltier]

The OP asked for one series with one cell from each of several worksheets.
This cannot be done. The data has to be compiled onto a single sheet.

This article describes the problem and a way to get around it:
http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html

- Jon