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
|
|||
|
|||
line chart expansion
I am using Excel 2003. I have a spreadsheet tab with numerous charts on it.
The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem. Any ideas on how I can fix this? |
#2
|
|||
|
|||
line chart expansion
The series that don't expand, is their data in a different workbook? Is the
different workbook open or closed? Is the data in a different worksheet in the same workbook? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "JR" wrote in message ... I am using Excel 2003. I have a spreadsheet tab with numerous charts on it. The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem. Any ideas on how I can fix this? |
#3
|
|||
|
|||
line chart expansion
I found that on the ones that were in different workbooks, if I saved those
workbooks the range updated in the chart. I now have one chart that gets the data from a tab in the same workbook, but the chart does not expand to the end of the data range (although it did expand part way once I saved the file). "Jon Peltier" wrote: The series that don't expand, is their data in a different workbook? Is the different workbook open or closed? Is the data in a different worksheet in the same workbook? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "JR" wrote in message ... I am using Excel 2003. I have a spreadsheet tab with numerous charts on it. The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem. Any ideas on how I can fix this? |
#4
|
|||
|
|||
line chart expansion
What technique is used to cause the chart's defined data range to expand
with the data in the source worksheet? Dynamic names, Lists, Tables? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "JR" wrote in message ... I found that on the ones that were in different workbooks, if I saved those workbooks the range updated in the chart. I now have one chart that gets the data from a tab in the same workbook, but the chart does not expand to the end of the data range (although it did expand part way once I saved the file). "Jon Peltier" wrote: The series that don't expand, is their data in a different workbook? Is the different workbook open or closed? Is the data in a different worksheet in the same workbook? - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "JR" wrote in message ... I am using Excel 2003. I have a spreadsheet tab with numerous charts on it. The charts pull data from other tabs within the same spreadsheet or from other spreadsheets entirely. When I expand the data each month, some of the charts grow with the new data and some do not. I can't see any difference in the data selections one chart to the next. I have expanded the source data and the x-label fields but still have the same problem. Any ideas on how I can fix this? |
Thread Tools | |
Display Modes | |
|
|