If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Change Y-Axis Run length?
Mystery solved. Sorry if I was a little dense. Otherwise I might have
figured out what you were trying to say. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Phil Smith" wrote in message ... I guess the Category axis is the X axis. My bad. Jon Peltier wrote: The week numbers ought to be in the X axis of a line chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Phil Smith" wrote in message ... I guess technically it is 51 weeks of data, covering a time period of 52 weeks, one week not returnign any data. Is that your point? Otherwise, what is it? Jon Peltier wrote: Let me restate: Why does the *Y axis* of a line chart go from 1 to 52 for 52 weeks worth of data? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Phil Smith" wrote in message .. . We closed our shipping and sales departments and therefore had no sales, during the last week and a day for comprehensive inventory count and reorganization. Otherwise it would have gone from 1 to 54. :-) Why does the Y axis of a line chart go from 1 to 52 for 52 weeks worth of data? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Phil Smith" wrote in message . .. I have a data table that uses data by week. That data has 52 weeks. I build a linechart and end up with a Y axis running from 1 to 52. Great. I replace that Data table via Cut and Paste with a data table that only goes from 1 to 26. The data in my chart changes to reflect that, (good,) but the Y-Axis still goes from 1 to 52, instead of 1 to 26. This wastes half of the space in my graph. I am going to eventually automate this with data From Access. How can I reset that Y-Axis to reflect the data? Thanx Phil |
|
Thread Tools | |
Display Modes | |
|
|