ng to openiHi

I run Excel 2000


I have a workbook with a number of charts in it. These charts have data on 2
axis.
The left axis has a bar chart with a calendar year label for each bar. The
right axis is a line chart with a Calendar Month label under each data point.

I copied these to a 2nd workbook so that when I update the charts in
workbook 1, they automatically update in workbook 2.

This works fine as long as I have both workbooks open at the same time.
However, if only the 2nd workbook is open the Calendar Month labels under the
line chart on axis 2 are no longer formatted to a date format but a number
format, however the Bar Chart on axis 1 still has the Calender Year label
under it.

As soon as I open the original workbook the labels on the 2nd workbook then
revert back to the normal date format.

Is the a way that I can retain the date formattiing on the charts of the 2nd
workbook without having open the original workbook?

I can reformat the axis for the Calendar Months on the 2nd work book charts
however as the lables under the bar chart on axis 1 is Calendar Year (2003,
2004, 2005, 2006) they then turn into a formatted month like the labels
under the line chart on axis 2.

Thanks

John

Hi Ng,

Sorry, I don't have 2000 on my machines any longer, but you might try
choosing the command Edit, Links, Update Links (if it's available and if its
even there in 2000).

--
Cheers,
Shane Devenshire


"John Calder" wrote:

ng to openiHi

I run Excel 2000


I have a workbook with a number of charts in it. These charts have data on 2
axis.
The left axis has a bar chart with a calendar year label for each bar. The
right axis is a line chart with a Calendar Month label under each data point.

I copied these to a 2nd workbook so that when I update the charts in
workbook 1, they automatically update in workbook 2.

This works fine as long as I have both workbooks open at the same time.
However, if only the 2nd workbook is open the Calendar Month labels under the
line chart on axis 2 are no longer formatted to a date format but a number
format, however the Bar Chart on axis 1 still has the Calender Year label
under it.

As soon as I open the original workbook the labels on the 2nd workbook then
revert back to the normal date format.

Is the a way that I can retain the date formattiing on the charts of the 2nd
workbook without having open the original workbook?

I can reformat the axis for the Calendar Months on the 2nd work book charts
however as the lables under the bar chart on axis 1 is Calendar Year (2003,
2004, 2005, 2006) they then turn into a formatted month like the labels
under the line chart on axis 2.

Thanks

John