chart errors

[Rich]

I have a file of 28 charts that is linked to 12 spreadsheets utilizing the
�source data� function within Excel. The spreadsheets are updated weekly (at
a minimum). When the chart files are opened, a pop-up asks if you want the
charts to update or not. I select the �update� option to update the charts
with the new data from the spreadsheets. This particular set of data was
entered on 6/22 and then again on 6/29. When I updated the charts, they all
updated with the new data with the exception of 4 charts linked to one
spreadsheet. All 24 other charts linked to the other 11 spreadsheets
displayed the 6/29 data. The 4 charts only show data to the 6/22 date, even
though the spreadsheet includes the 6/29 data.

I have checked all formulas associated with these charts and they are
formatted exactly as the formulas that updated. When the �source data� is
opened and the series is viewed, it encompasses (dotted line circling the
data column) the 6/29 data. I can see no logical reason for this one
spreadsheet not to update the 4 charts.

Can anyone help?

[Tushar Mehta]

For those charts that do not update, are the x or y-scales set to=20
manually specified min/max values? Double-click the x-axis then check=20
the Scale tab. Do the same for the y-axis.

--=20
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,=20
[email protected] says...
> I have a file of 28 charts that is linked to 12 spreadsheets utilizing th=
e=20
> =E2=A4=BDsource data=E2=A4=9D function within Excel. The spreadsheets are=
updated weekly (at=20
> a minimum). When the chart files are opened, a pop-up asks if you want th=
e=20
> charts to update or not. I select the =E2=A4=BDupdate=E2=A4=9D option to =
update the charts=20
> with the new data from the spreadsheets. This particular set of data was=
=20
> entered on 6/22 and then again on 6/29. When I updated the charts, they a=
ll=20
> updated with the new data with the exception of 4 charts linked to one=20
> spreadsheet. All 24 other charts linked to the other 11 spreadsheets=20
> displayed the 6/29 data. The 4 charts only show data to the 6/22 date, ev=
en=20
> though the spreadsheet includes the 6/29 data.
>=20
> I have checked all formulas associated with these charts and they are=20
> formatted exactly as the formulas that updated. When the =E2=A4=BDsource =
data=E2=A4=9D is=20
> opened and the series is viewed, it encompasses (dotted line circling the=
=20
> data column) the 6/29 data. I can see no logical reason for this one=20
> spreadsheet not to update the 4 charts.
>=20
> Can anyone help?
>=20
>=20

[Rich]

Thanks Tushar for the input. As I said in my original message, all charts,
including the X & Y axis' are formated identically. The other 24 charts
updated from the other 11 spreadsheets as I expected. It is only a problem
with these 4 charts from this one spread sheet.

To answer your question about the values; no, they are not manually set.
all charts are linked to values from the same source.

Thanks again for your input. This is a strange one.

Regards

Rich

"Tushar Mehta" wrote:

> For those charts that do not update, are the x or y-scales set to
> manually specified min/max values? Double-click the x-axis then check
> the Scale tab. Do the same for the y-axis.
>
> --
> Regards,
>
> Tushar Mehta
> www.tushar-mehta.com
> Excel, PowerPoint, and VBA add-ins, tutorials
> Custom MS Office productivity solutions
>
> In article <[email protected]>,
> [email protected] says...
> > I have a file of 28 charts that is linked to 12 spreadsheets utilizing the
> > “source data” function within Excel. The spreadsheets are updated weekly (at
> > a minimum). When the chart files are opened, a pop-up asks if you want the
> > charts to update or not. I select the “update” option to update the charts
> > with the new data from the spreadsheets. This particular set of data was
> > entered on 6/22 and then again on 6/29. When I updated the charts, they all
> > updated with the new data with the exception of 4 charts linked to one
> > spreadsheet. All 24 other charts linked to the other 11 spreadsheets
> > displayed the 6/29 data. The 4 charts only show data to the 6/22 date, even
> > though the spreadsheet includes the 6/29 data.
> >
> > I have checked all formulas associated with these charts and they are
> > formatted exactly as the formulas that updated. When the “source data” is
> > opened and the series is viewed, it encompasses (dotted line circling the
> > data column) the 6/29 data. I can see no logical reason for this one
> > spreadsheet not to update the 4 charts.
> >
> > Can anyone help?
> >
> >
>