Order of X-axis
 

Dearest Wizards,

Col A has dates, in order but with most recent toward top. Col D has data
to be graphed. What I want is for the resulting graph to have the most
recent date on the RIGHT side of the graph (on the X-Axis) and the earliest
dates on the LEFT. The order on the spreadsheet really can't be changed to
accommodate this.

TIA for any help you can give.
Sam

Order of X-axis
 

Hi,

Double click the X axis and on the scale tab of the format dialog check,
Dates in Reverse order
To keep the Y axis labels on the left also check
Value (Y) axis crosses at maximum value

Cheers
Andy


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Metolius Dad" wrote in message
...
Dearest Wizards,

Col A has dates, in order but with most recent toward top. Col D has data
to be graphed. What I want is for the resulting graph to have the most
recent date on the RIGHT side of the graph (on the X-Axis) and the
earliest
dates on the LEFT. The order on the spreadsheet really can't be changed
to
accommodate this.

TIA for any help you can give.
Sam