x-axis dates

[Gene]

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?

 

[Gene]

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.

 

[Jon Peltier]

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

 

[Gene]

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