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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Position of X axis labels 4
Chart with differing x axis 1
X axis Scale 8
Line Chart - Problems with labeling X-Axis 3
Changing y axis labels 1
Date/Time on X axis 3
scatter chart won't accept primary axis 4
Hide Graph of Data Outside X-Axis Range 2

Back
Top