date axis change bug???

  • Thread starter Thread starter Keith Reiss
  • Start date Start date
K

Keith Reiss

GIVEN A SCATTER PLOT WITH THE X-AXIS AS DATES, TRYING THO ALTER THE
START/STOP DATES IN THE OPTIONS BOX IS PROBLEMMATIC. iT WILL not ACCEPT A
DATE, BUT ONLY A SERIAL NUMBER. It should DISPLAT the start/stop dates as
dates anot serial numbers. At the least, it ought to make the conversion
autonomously. HELP!!!!
 
Don't use all caps.

In Excel versions up to 2003, this is not a problem, so I presume you are
using 2007. If SP1 is installed it should also not be a problem. I did have
some issues with this recently, though, and discovered if I applied a date
type of number format to the axis tick labels first, Excel was much happier
accepting dates in the XY chart axis scale entry boxes.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/>
Advanced Excel Conference - Training in Charting and Programming
http://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______
 
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

How do I put words as the Y axis values? 0
Defining X-axis scales as dates or times 3
Plotting Date and Time on the same chart axis 1
Trying to change x-axis date range 5
Date Range for X-Axis Labels 2
Plotting against Date (collating months) 1
2nd axis plotting incorrectly - is there a chart size limit? 2
Excel 2007: Line where a gap should be, but only when plotting on ahorizontal date axis 2

Back
Top