Title : Primary horizontal axis picks the wrong base unit for date values, when changed it messes up the dates on the horizontal axis
Hi,
I have a chart with 2 'Line' series using the primary vertical axis (log scale) and 1 'Column' using the secondary vertical axis (default)
My horizontal axis has dates
The problem I have is that Excel 2007 automatically picks the wrong base unit (days instead of months) for the horizontal axis. When I change it to use months it messes up my horizontal dates to dates way in the future.
My data looks like this (4 columns).
mar-10 1.12 1.34 1
apr -10 1.22 1.44 0
may -10 1.33 1.55 1
...
The idea is to show 2 trend lines and a horizontal columns when the 4th value is 1 (indicating a recession)
The strange thing is that I have 9 sheets with different data sets but identical in setup, 7 of the sheets have a correct graph (because base unit is month) and 2 do not (base unit is days). To be clear the setup, format, setting of the graphs etc. is all identical, the actual data is different.
Any help is appreciated
Michiel
Bookmarks