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

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

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

I discovered that if i use COUNTA instead of COUNT in the OFFSET formula for
dynamic data entry the horizontal axis remains a "catagories" type. But a
problem still occurs when I add a scatter chart. The axis dates change to a
'95 year format limit and the chart goes into a non-responding mode
thereafter. No amount of adjusting works after that.--
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