Browse » Home
Saturday, February 25, 2012
How to Change the X
1. Open Excel and navigate to the chart for which you wish to change the x-axis range.
2. Move your cursor so that it is directly over the x-axis of the chart, and right-click with your mouse.
3. Select 'Format Axis...' from the menu that appears. The Format Axis dialog box will open.
4. Click so that 'Fixed' is selected instead of 'Automatic' for both the Minimum and Maximum under Axis Options.
5. Select the values you wish to use as the minimum and maximum for the x-axis and enter them in the appropriate boxes. Click 'Close' to finish.