hierarchical axis labels reverse chart

[steve]

When I change a chart from single level axis labels, to multiple level
(hierarchical) data labels, the data on my chart reverses direction.
(eg. originally the newest data is on the right, after I switch to multiple
level data labels, the newer data is on the left)

Is there any way to fix this?

 

[steve]

I still don't know why excel does this, so I simple have reversed the graph
and worked around it.