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
|
|||
|
|||
Chart Data Table, Data Range, etc. do not update on Chart
I have two Excel Workbooks. Workbook 1 contains the data and a line chart. Workbook 2 contains just a line chart of the same data as in Workbook 1. I copied the line chart from workbook 1 to workbook 2 using copy/paste. If the amounts change with in the existing data range then both line charts (workbook 1 & workbook 2) update fine. However, when I need to change the range of the data to include more cells only the line chart in workbook 1 is updated. The line chart in workbook two does not reflect the changes to the data range made to the line chart in workbook 1. What is the best way to get aound this. My goal is to only have to update in one place.
|
#3
|
|||
|
|||
Chart Data Table, Data Range, etc. do not update on Chart
Richard -
Do you mean you're changing the size of the data range in the chart in workbook 1? The chart in Workbook 2 has no way of knowing what the range is for the chart in workbook 2. You could use dynamic ranges to define the X and Y values for the series, so that you change the range not by the source data dialog, but by changing some parameters in the data sheet that affect the start and end row and the appropriate column for your series. Then if both charts refer to the same defined ranges, when the range is updated, both charts should update. For more on dynamic charts: http://www.geocities.com/jonpeltier/.../Dynamics.html (a few examples and many links) http://pubs.logicalexpressions.com/P...cle.asp?ID=246 (another of my examples in TechTrax ezine) - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ RichardS wrote: I have two Excel Workbooks. Workbook 1 contains the data and a line chart. Workbook 2 contains just a line chart of the same data as in Workbook 1. I copied the line chart from workbook 1 to workbook 2 using copy/paste. If the amounts change with in the existing data range then both line charts (workbook 1 & workbook 2) update fine. However, when I need to change the range of the data to include more cells only the line chart in workbook 1 is updated. The line chart in workbook two does not reflect the changes to the data range made to the line chart in workbook 1. What is the best way to get aound this. My goal is to only have to update in one place. |
#4
|
|||
|
|||
Chart Data Table, Data Range, etc. do not update on Chart
Tushar & Jon,
Thank you both for your reply. I was manually adjusting the ranges in workbook 1. I will follow Jon's advice and try and create some dymanic ranges that will update both charts. |
Thread Tools | |
Display Modes | |
|
|