Thread: chart errors

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?

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 <FB9D454E-DF85-4519-9CEE-F0002F4404F5@microsoft.com>,=20
Rich@discussions.microsoft.com 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

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 <FB9D454E-DF85-4519-9CEE-F0002F4404F5@microsoft.com>,
> Rich@discussions.microsoft.com 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?
> >
> >
>