If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
multiple sheets
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. |
#2
|
|||
|
|||
multiple sheets
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" wrote: 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. |
#3
|
|||
|
|||
multiple sheets
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" wrote: 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" wrote: 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. |
#4
|
|||
|
|||
multiple sheets
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 "Marty" wrote: 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" wrote: 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" wrote: 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. |
#5
|
|||
|
|||
multiple sheets
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/ChartsH...iffSheets.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "FloMM2" wrote in message ... 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 "Marty" wrote: 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" wrote: 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" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|