You can change the range of data that is used for X values (if in fact any were
assigned when the chart was created). Choose Source Data from the Chart menu.
To change the scale of the X axis (if you have an XY Scatter chart), double click
the axis, and make adjustments on the Scale tab. You can't significantly change the
scale of a category axis in a line chart.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions http://PeltierTech.com/
_______
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.