Double click the axis, click on the Scale tab, and enter 1 where it says
Number of Categories between Tick Mark Labels (even if it says 1 already,
click in the box and press Enter).
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
wrote in message
...
Does anyone know if there is a limit to the number of items you can
have on the x-axis of a chart in MS excel? Right now I am being
limited to 7 (e.g. when I try to add more than 7 values to my data
series, I am unable to so). Thanks!