Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
 
Posts: n/a
Default Graph values in ascending order

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
  #2   Report Post  
Gord Dibben
 
Posts: n/a
Default

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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why is the order of my data table opposite from graph? mozermodo Charts and Charting in Excel 6 April 25th 23 03:43 AM
graph displayed in ascending order of value? [email protected] Charts and Charting in Excel 3 January 7th 05 05:21 AM
Bar graph values keep changing Mike82j2000 Charts and Charting in Excel 1 January 6th 05 02:27 PM
Graph Axes Robin Excel Discussion (Misc queries) 0 December 8th 04 09:03 PM
how to paste the values in reverse order in workbook nayeemoddin Excel Discussion (Misc queries) 2 December 6th 04 09:35 AM


All times are GMT +1. The time now is 02:06 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"