Thread: Order of X-axis
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default 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