View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Chart Shows data wrong way around

I don't know why yours is backwards. If it is a horizontal bar chart, the
bars start with the first at the bottom (closest to the origin), which is
the opposite of their order in the worksheet.

Double click the "backwards" axis, check the "Categories in reverse order"
box and the "Value axis crosses at maximum category" box. Or if they're both
checked, uncheck them.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
Hi,

I have this strange problem with a simple chart.
Y Axis shows correct £0.00 - and scaling upwards.

X Axis is the problem.

As you look at the chart the X axis displays the days correct 1 2 3 4
5 and so on.
Now the problem is the actual bars read right to left, so day 1 has
the bar over it for the last day and the last day has the bar for day
1.

I am no way an Excel expert :) so if this is something very obvious
then "opps" but any help is much appreciated on how to have them
matching up correctly.