Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 text labels in category axis - missing labels | Charts and Charting in Excel | |||
xy-scatter-labels disappear when x-axis is changed into time-axis (XL07) | Charts and Charting in Excel | |||
problem saving an open excel workbook | Excel Worksheet Functions | |||
Chart problem: values in column A don't show as labels on x-axis | Excel Discussion (Misc queries) | |||
How do I get around the problem where x and y axis labels in Micr. | Charts and Charting in Excel |