multiple sheets


M

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

Advertisements

F

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
 
M

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

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top