Indezine Logo




Changing Axis Labels in PowerPoint 2010 for Windows

Learn how to change axis labels in PowerPoint 2010 for Windows. We explore changing category and value axis labels.


Author:

Product/Version: PowerPoint 2010 for Windows

OS: Microsoft Windows XP and higher



Learn PowerPoint

Learn how to animate 3D models in PowerPoint without the Morph transition effect.



Axis labels are like captions for categories and values on chart axes. Figure 1, below that shows the default position of axis labels for a column chart. Category names, which show as labels on the horizontal (category) axis have been highlighted in blue. Similarly, values show as labels on the vertical (values) axis, and these are highlighted in red.

Default Axis Labels in a Column chart
Figure 1: Default axis labels in a column chart

So, where do these labels come from? Category axis labels reflect category names within your data (typically within the built-in Excel sheet). Values on the other hand are determined by PowerPoint based upon the maximum value in your data, and the minimum value is always set to zero. Of course you can change minimum and maximum values if you want.

Value Formats

Values are typically shown as numbers or percentage values. They can also have decimals.

Before you begin, you should have a chart inserted in your PowerPoint slide. We use a column chart for this example.

Follow these steps to learn how you can change your axis labels. Let's start with changing vertical (value) axis labels in PowerPoint 2010 for Windows:

  1. Select the value axis of the chart on your slide and carefully right-click to access the contextual menu, as shown in Figure 2, below. From the contextual menu, choose Format Axis option (refer to Figure 2 again). If you do not get the Format Axis option in the contextual menu, you may have right-clicked on another chart element. Make sure you then deselect everything in the chart, and then carefully right-click on the value axis.
  2. Format Axis option selected for the Value Axis
    Figure 2: Format Axis option selected for the value axis
  3. Doing so opens the Format Axis dialog box, as shown in Figure 3, below.
  4. Format Axis dialog box
    Figure 3: Format Axis dialog box
  5. In Figure 3 above, you can see all of the vertical axis' Minimum, Maximum, Major unit, and Minor unit options are set to default values. We know so because the Auto radio button is selected for all these options, as can be seen in Figure 3, above. If you change the maximum or minimum values, or change the major or minor units, you will see the vertical axis labels reflecting changes you made. Also, the Auto radio button will no longer be selected for changed options, and will be set to the Fixed radio button. To change any of these values, first you need to select the Fixed radio button associated with the option you want to change. Then, enter the required value within the box towards the right of the radio button.
  6. Look at Figure 4, below where we have set the Maximum value to 10 as shown highlighted in red. You can see a live preview of the vertical axis label automatically reflecting this change, showing the maximum value changed to 10, as shown highlighted in blue within Figure 4. Compare this to the original chart shown in Figure 1, previously on this page.
  7. Value Axis Label reflecting the changed Maximum value
    Figure 4: Value axis label reflecting the changed Maximum value
  8. Now, look at Figure 5, below where we have changed the Display units to Hundreds as shown highlighted in red. Notice that the vertical axis label now shows the changed display units as shown highlighted in blue within Figure 5.
  9. Value Axis Label reflecting the changed Display units
    Figure 5: Value axis label reflecting the changed display units
  10. You can also change the value axis label to show as Currency. To do so, select the Number option in the sidebar as shown highlighted in green within Figure 6, below. Thereafter select Currency within the Category list shown highlighted in red within Figure 6. You can choose the Currency symbol you need, and also set the required number of decimal spaces. You can see that the resultant value axis label shown highlighted in blue within Figure 6 is now set to Currency.
  11. Value Axis Label changed to Currency
    Figure 6: Value axis label changed to Currency
  12. You can similarly change value labels to show Percentages, Fractions, etc.

Now, let us learn how to change category axis labels.

  1. First select your chart. Then, click the Edit Data button within the Charts Tools Design tab of the Ribbon, as shown highlighted in red within Figure 7, below.
  2. Edit Data button within Data group
    Figure 7: Edit Data button within Data group
  3. Doing so opens an instance of Excel with your chart data. Change category names within the Excel sheet. Look at Figure 8, below where we have changed our category names, as shown highlighted in red.
  4. Category names changed within the Excel sheet
    Figure 8: Category names changed within the Excel sheet
  5. Now, exit Excel. Changes you made to category names in Excel will automatically be reflected in the category axis labels of your chart within PowerPoint as shown highlighted in red within Figure 9, below. Compare this with the original chart shown in Figure 1, previously on this page.
  6. Chart reflecting the changed category names
    Figure 9: Chart reflecting the changed category names
  7. Save your presentation.

See Also:

Chart Axes: Changing Axis Labels (Glossary Page)

Changing Axis Labels in PowerPoint 2013 for Windows
Changing Axis Labels in PowerPoint 2011 for Mac

You May Also Like: Presentation Procrastinators: 04 | Accounting PowerPoint Templates


Popular Posts

Add Pattern Fills to Shapes in PowerPoint 2010 for Windows
Add Pattern Fills to Shapes in PowerPoint 2010 for Windows
Add pattern fills to shapes in PowerPoint 2010 for Windows.

Gradient Fills for Text in PowerPoint 2013
Gradient Fills for Text in PowerPoint 2013
Learn how to add gradient fills to selected text in PowerPoint 2013.

Formatting Outlines for Shapes (Dashes) in PowerPoint 2013 for Windows
Formatting Outlines for Shapes (Dashes) in PowerPoint 2013 for Windows
Learn how to apply the dash attribute to shape outlines in PowerPoint 2013 for Windows.

Change the Unit of Measurement in Windows 10
Change the Unit of Measurement in Windows 10
Learn how to change the unit of measurement from US to Metric, and vice versa in Windows 10.



Ebook PowerPoint Keyboard Shortcuts

PowerPoint Keyboard Shortcuts and Sequences Ebook

PowerPoint 365, 2019, 2016, 2013, 2011, 2010, 2007 and 2003 for Windows

PowerPoint 365, 2019, 2016 and 2011 for Mac

PowerPoint for the Web on Windows and Mac

Have you ever used keyboard shortcuts and sequences in PowerPoint? Or are you a complete keyboard aficionado? Do you want to learn about some new shortcuts? Or do you want to know if your favorite keyboard shortcuts are documented?

Go and get a copy of our PowerPoint Keyboard Shortcuts and Sequences ebook.

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Changing Axis Labels in PowerPoint 2010 for Windows.


Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.

Home | PowerPoint | Photoshop | PowerPoint Templates | PowerPoint Tutorials | Blog | Notes | Ezine | Advertise | Feedback | Site Map | About Us | Contact Us

Link to Us | Privacy | Testimonials

PowerPoint Backgrounds | Christian PowerPoint Backgrounds | Business PowerPoint Presentation Templates

Plagiarism will be detected by Copyscape

©2000-2021, Geetesh Bajaj. All rights reserved.