Axis labels problem when referenced workbook not open...

I recently migrated three workbooks from excel 2003 - 2007.

The problem I describe does not happen in 2003.
There were no errors when converting the files.

Charts.xlsx references chart data from two sources, sourceOne.xlsx and
sourceTwo.xlsx.

Now when ALL THREE workbooks are open, the charts display (as they should)
the proper 'major units' (which is monthly) so for a series of 365 days,
there twelve x-axis dates presented.

However, when I close the source workbooks, the charts ignore the 'Major
Units' and return to displaying a label for every day in the data (365
labels).

This is not only not readable but also makes the 20 or so charts on the page
load extremely slowly.

Has anyone run into this and figured out a way to fix it?

Thanks!

I have bad news, Excel 2007 charting is atrocious compared to 2003. The only
resolution is to replot your charts from scratch in a clean 2007 worksheet.
This worked for me but I am also curious to discover what is the conflict.

If this helps please click "Yes"


"InquiringMind" wrote:

I recently migrated three workbooks from excel 2003 - 2007.

The problem I describe does not happen in 2003.
There were no errors when converting the files.

Charts.xlsx references chart data from two sources, sourceOne.xlsx and
sourceTwo.xlsx.

Now when ALL THREE workbooks are open, the charts display (as they should)
the proper 'major units' (which is monthly) so for a series of 365 days,
there twelve x-axis dates presented.

However, when I close the source workbooks, the charts ignore the 'Major
Units' and return to displaying a label for every day in the data (365
labels).

This is not only not readable but also makes the 20 or so charts on the page
load extremely slowly.

Has anyone run into this and figured out a way to fix it?

Thanks!