Thursday, April 12, 2012

How to Change X Axis Values in Excel 2007


1. Click on the x-axis to select it. Click somewhere beneath the bottom horizontal line of the chart to ensure that you select the axis rather than the chart area.
2. Right-click within the selected area and choose 'Format Axis' from the drop-down menu that appears.
3. Click the circle for 'Fixed' next to 'Minimum:' under 'Axis Options' and type the smallest number you want displayed on the x-axis in the box to the right. Do the same for 'Maximum:' but type the largest number you want displayed on the x-axis.
4. Select the 'Fixed' circle next to 'Major unit:' and enter a number in the box to the right if you want to change what numbers are displayed on the x-axis. For example, type '0.1' into the box if you want to display every tenth.
5. Click the 'Close' button at the bottom of the 'Format Axis' box to accept your changes.

Blogger news