how do I flip the data so my chart shows in chronological order?

[noname]

column A=12/2005
B=11/2005
C=10/2005
etc.

How do I flip the raw data around so that my graph shows in
chronological order?
Thanks!

 

[Max]

Perhaps a simple, quick way ..
Insert 2 new cols D & E (if necessary)
Put in D1: =IF(A1="","",A1)
Copy D1 to E1, fill down
Then re-plot* the graph on cols C to E (instead of A to C)
*or re-point the existing source at cols C to E

 

[Max]

Oops, correction ..

Lines

Put in D1: =IF(A1="","",A1)
Copy D1 to E1, fill down

should read as:

Put in D1: =IF(B1="","",B1)
Put in E1: =IF(A1="","",A1)
Select D1:E1, fill down

---

 

[Andy Pope]

Hi,

If you only want the chart in the correct order then,
double click the axis and on the Scale tab tick both
Categories in reverse order.
Value (Y) axis crosses at maximum.

Cheers
Andy