How to Change the Display of Axes in Excel

The way information is displayed on the primary horizontal and vertical axes of a chart can be customized in Microsoft Excel 2007. You can choose to have your data show up on a certain side of the axis or be displayed in a certain amount. Follow the steps below to find out how you can change the display of axes in your chart in Excel.

Instructions

Difficulty: Easy

Things You’ll Need:

• Microsoft Excel 2007

1. Start Microsoft Excel 2007 and open an existing workbook that contains a chart that you would like to change the display of the axes.
2. Click the chart that you want to change the display of the axes so it is selected. The chart will have a light blue border surrounding it, indicating that it is selected.
3. Choose the "Axes" button in the "Axes" section of the "Layout" ribbon. A drop-down menu will appear.
4. Point to "Primary Horizontal Axis" to view the options for changing the display of the primary horizontal axes. The display options for your primary horizontal axis will be displayed in a menu. Click on the title and description that you want to apply to your primary horizontal axis.
5. Select the "Axes" button in the "Layout" ribbon once again and point to "Primary Vertical Axis." Click on a title and description for the display option you want to apply your primary vertical access.

Tips & Warnings

• The display options you see under "Primary Horizontal Axis" and "Primary Vertical Axis" are dependent upon the type of data you are using in each section of your chart.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.