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