Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
date axis change bug???
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!!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
date axis change bug???
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...00906ACNJ.html _______ "Keith Reiss" <Keith wrote in message ... 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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change x axis date scale on multiple charts quarterly | Charts and Charting in Excel | |||
How do I change where category x axis crosses the 2nd y axis? | Charts and Charting in Excel | |||
How do I force a secondary horizontal axis to act as a date axis? | Charts and Charting in Excel | |||
How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel |