| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Change Y-Axis Run length?
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
You should be able to click on the specific axis, then right click and format
axis. Under Scale, you should be able to change the axis range. -- TG "Phil Smith" wrote: 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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
Thanx, but that is not going to cut it for this project. I need the
axis to change based on the data it is presented. Updating the data should update the chart, including the axis. Both the X and Y axis may change by a couple of orders of magnitude between runs. Having to go in manually and change that each time, (currently expected to be more than twenty times per day,) is just not feasible. I thought the whole power of a spreadsheet was to automatically adjust everything revolving around the data as the data is changed. Got anything else? Thanx Phil Gerigto wrote: You should be able to click on the specific axis, then right click and format axis. Under Scale, you should be able to change the axis range. |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
If you set the axis options to auto, then it will adjust to suit your data,
but it will do it in the way it wants, which isn't necessarily the way you would prefer it. -- David Biddulph "Phil Smith" wrote in message ... Thanx, but that is not going to cut it for this project. I need the axis to change based on the data it is presented. Updating the data should update the chart, including the axis. Both the X and Y axis may change by a couple of orders of magnitude between runs. Having to go in manually and change that each time, (currently expected to be more than twenty times per day,) is just not feasible. I thought the whole power of a spreadsheet was to automatically adjust everything revolving around the data as the data is changed. Got anything else? Thanx Phil Gerigto wrote: You should be able to click on the specific axis, then right click and format axis. Under Scale, you should be able to change the axis range. |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
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 |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
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 |
|
#7
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
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 |
|
#8
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
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 |
|
#9
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
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 |
|
#10
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Change Y-Axis Run length?
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 |
|
#11
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the length of the dropdown list used to cell entries | Excel Discussion (Misc queries) | |||
| can you change the length of a drop down box | Excel Discussion (Misc queries) | |||
| Change the length of the page bar | Excel Discussion (Misc queries) | |||
| Can you change the length of an excel chart data label? | Charts and Charting in Excel | |||
| Axis length | Charts and Charting in Excel | |||
Linear Mode
