If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Axis labels problem when referenced workbook not open...
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! |
Thread Tools | |
Display Modes | |
|
|