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

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
>

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.

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.

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" <(E-Mail Removed)> wrote in message
news:u1%(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> news:u1%(E-Mail Removed)...
>
>>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
>
>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:u1%(E-Mail Removed)...
>>
>>>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
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>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" <(E-Mail Removed)> wrote in message
>>>news:u1%(E-Mail Removed)...
>>>
>>>
>>>>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
>>>
>>>
>

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>
>>>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" <(E-Mail Removed)> wrote in message
>>>>news:u1%(E-Mail Removed)...
>>>>
>>>>
>>>>>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
>>>>
>>>>
>>

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" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>>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" <(E-Mail Removed)> wrote in message
>>>news:(E-Mail Removed)...
>>>
>>>
>>>>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" <(E-Mail Removed)> wrote in message
>>>>>news:u1%(E-Mail Removed)...
>>>>>
>>>>>
>>>>>
>>>>>>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
>>>>>
>>>>>
>
>