They made this more confusing than it used to be, and the units in which you
can enter axis limits misbehave. Try changing the number format of the axis
tick labels to a date format. This may allow you to enter axis scale
parameters as dates.

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______



"Gene" wrote in message
...
Perhaps I can better explain my problem. When I select the x-axis to
reformat instructions are that I should be able to change axis type. That
assumes I have horizontal (catagories) listed. I have horizontal(values)
and
there is no type to change.
--
GeneS


"Gene" wrote:

I have set up my line chart in 2007 with dynamic paramaters (names) and
since
then the date catagory is controlled by horizontal(values). The axis
values
are numbers even though the labels appear as dates. I have to use the
microsoft numbers to determine the axis start and end limits. What
happened?
--
GeneS