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