Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
dates as minimum axis values
Excel versions prior to Excel 2007 allowed dates to be entered as minimum
axis values for XY charts on the axis format scale menu. In Excel 2007 when I attempt to enter a date as a minimum value, i.e. attempting to enter 1-1-2007 with the Fixed radio button selected in Axis Options, the automatic value pops back up unchanged. I can successfuly enter a numeric value, but not a date. This requirement adds several extra steps - calculating a date value and typing the resulting number, then deleting the calculation - to what used to be a simple process. If anyone knows that the same capability still exists in Excel 2007 that I've just not found, please enlighten me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Set Minimum Y Axis Values | Excel Worksheet Functions | |||
Auto minimum on Y Axis | Charts and Charting in Excel | |||
line graph-need to pick up dates as values for the x axis? | Charts and Charting in Excel | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel |