date axis change bug???

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!!!!
 
J

Jon Peltier

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
_______
 

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

Plotting Date and Time on the same chart axis 1
Defining X-axis scales as dates or times 3
Trying to change x-axis date range 5
Creating a dynamic chart range where the range to be graphed depends on the contents of a cell 0
2007: Can't set axis max by date 3
2nd axis plotting incorrectly - is there a chart size limit? 2
Axis formatting 0
X Y Scatter Chart - Dates on X axis starting at 1900 1

Top