From: Cycleboy on
I plotted rainfall data and river levels on an X-Y graph. I then changed the
way the rainfall was displayed from a line into columns. Unfortunately,
Excel changed the way it treated the rainfall data, changing it from a time
series into categories and creating a hidden secondary X-axis.

While this may be understandable, Excel also alterred the maximum value of
the X axis, changing it from 60 down to 48. This meant that the position of
each column did not line up with the corresponding hour on the primary axis.
This wouldn't have been a major problem if the secondary axis as visible, but
it was not. Hence, it was not obvious (to me) why the two traces no longer
'lined up' as they should.

If Excel is going to change the way it handles a data series, IT SHOULD DO
IT IN A TRANSPARENT WAY, and not surreptitiously.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/community/en-us/default.mspx?mid=81f71b4a-6e7a-4fa2-a044-515be2316c25&dg=microsoft.public.excel.charting