Greetings,
I have just created a workbook with one chart. I finished the project, saved the file, closed it and reopened it. When reopened the x axis labels for the chart (a column bar chart) changed from being aligned with the categories to all stacked under the first category (I'll try to attach jpg).
I have checked and played with all the settings I could find but to no avail. Any ideas?
TIA,
WD
Do you have the latest SP for excel installed? That would be SP2
I'm sorry, "SP"? Is that some sort of update? Please explain.
service pack ... right. I'll check.
Correct ServicePack.
Office Button > Excel Options > Resources > About
Yes, I have(had) already installed SP2.
Other ideas?
Post the workbook, sanitized as necessary.
Entia non sunt multiplicanda sine necessitate
ok, no macros, fairly plain.
Thanks!
Very strange. Opens fine in 2003, not fine in 2007. I played with it, but have no suggestions. Perhaps Andy will teach us both something.
The problem is related to the blank column of information between category labels tand the first series.
If you enter information in there you will get the expected multi-level labels. Clear those cells and the axis becomes confused upon re-openning.
That said there is something different about your chart to the one I created.
If you check the Select Data for your chart there is no overall range references.
Where as my chart the overall range of ='Summary Table'!$B$5:$F$11
appears and the axis does not have a problem. Even with empty column C.
How exactly did you construct the chart?
Do you really need the empty column C?
Brilliant! Fixed. Column C was not necessary.
One question, is it possible to remove that file that I submitted or is it your policy to leave it so people can fully follow the thread?
Thanks so much!!
WD
We prefer to keep the files available as it helps anybody searching for a solution.
That said if the information is 'confidential' then it can be revised to protect the innocent.
oh, and I'm sorry but I do not recall how I created the chart. I do know that I am not pleased with the 2007 chart creation interface. Controls seem too buried and scattered (to me at least).
Thanks again,
WD
No, not confidential. It's just that it's being used for some Excel training classes and is in a sense proprietary to my company. But, I posted it so I'm the only one to blame.
No Problem
(btw ... it stumped at least three people who can be classified as Excel experts, so nice work diagnosing.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks