line chart expansion JR 12/22/2008 8:36:11 PM 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?

Re: line chart expansion "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/23/2008 5:19:05 AM 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" <JR[ at ]discussions.microsoft.com> wrote in message news:2DC83477-7907-4F26-8FD7-3D0F9076AD50[ at ]microsoft.com... [Quoted Text] >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?

Re: line chart expansion JR 12/23/2008 5:26:15 PM 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: [Quoted Text] > 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" <JR[ at ]discussions.microsoft.com> wrote in message > news:2DC83477-7907-4F26-8FD7-3D0F9076AD50[ at ]microsoft.com... > >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? > > >

Re: line chart expansion "Jon Peltier" <jonxlmvpNO[ at ]SPAMpeltiertech.com> 12/26/2008 4:48:47 AM 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" <JR[ at ]discussions.microsoft.com> wrote in message news:2A29356E-E6F3-4B4A-A252-B83F8B079809[ at ]microsoft.com... [Quoted Text] >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" <JR[ at ]discussions.microsoft.com> wrote in message >> news:2DC83477-7907-4F26-8FD7-3D0F9076AD50[ at ]microsoft.com... >> >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? >> >> >>