graph displayed in ascending order of value?

  • Thread starter Thread starter anthony.greening
  • Start date Start date
A

anthony.greening

I would like my graph to shows values in ascending order
on the x-axis. I know how to do this manually however as
the values change on a weekly basis I would like the
graph to autoimatically do this for.

regards Ant
 
You can do this on an XY chart. On the format axis menu, you can change
the scale to display the values in reverse order. If you are using
something besides an XY chart, please let us know.
 
Hi,
thanks for the reply but when I chnged the scale to
display values in reverse order the chart I'm using
displayed the same information only upside down. Am I
doing something wrong?

Cheers Ant
 
Anthony -

Did you format the right axis? What's the data look like? Remember, if you change
the order on the X axis, the shape of the plotted data will change.

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