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

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

On Thu, 6 Jan 2005 04:01:19 -0800, "Ant "
wrote:

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