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