>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?
>>
>>
>>