Graph values in ascending order

[Ant 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

 

[Gord Dibben]

Ant

A graph represents the data as you have laid it out on the data sheet.

If you want the data in ascending order, you will have to sort on a weekly
basis.

To do it automatically would require VBA, the graph will not do it for you.


Gord Dibben Excel MVP