Order of X-axis

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top