![]() |
x-axis dates
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 |
x-axis dates
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 |
x-axis dates
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 |
x-axis dates
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 |
All times are GMT +1. The time now is 05:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com