| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dates on scatter chart axis
In setting the scale (Minimum and Maximum under Axis Options) a scatter data
graph axis, in Excel 2003 you could enter the date (e.g., 1/1/1987) . In Excel 2007 it appears I can only enter the number (e.g., 31778) which is quite difficult. Is there a way in Excel 2007 to enter the date? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
dates on scatter chart axis
No. Jon Peltier has pointed that out as one of a number of retrograde
changes in Excel 2007. As he has pointed out, the easiest option is to use a worksheet to put the date you require into a cell and allow the sheet to do the conversion to 31178, so that you can see which number to type (or copy) into the Axis dialogue. -- David Biddulph "Jake" wrote in message ... In setting the scale (Minimum and Maximum under Axis Options) a scatter data graph axis, in Excel 2003 you could enter the date (e.g., 1/1/1987) . In Excel 2007 it appears I can only enter the number (e.g., 31778) which is quite difficult. Is there a way in Excel 2007 to enter the date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| XY Scatter chart - Axis Option | Charts and Charting in Excel | |||
| Scale on X & Y Axis of the scatter chart | Charts and Charting in Excel | |||
| How do I add a second y-axis in an xy(Scatter) chart? | Charts and Charting in Excel | |||
| Scatter Chart Axis as text C# | Charts and Charting in Excel | |||
| the dates to label the x axis on the scatter chart won't print | Charts and Charting in Excel | |||
Linear Mode
