graph displayed in ascending order of value?

  • Thread starter anthony.greening
  • 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
 
B

Barb Reinhardt

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.
 
G

Guest

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
 
J

Jon Peltier

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting the graph style I want 4
Use text descriptors as Y axis units 1
Make Y-axis values correspond to x- axis value 1
Extrapolation and Interpolation questions 0
Graph values in ascending order 1
Plotting against Date (collating months) 2
Automatic Macro to create 200 graphs 1
Ordering the chart by value 0

Top