Home | Products | PowerPoint | PowerPoint Tutorials | Charts

Change Major and Minor Units of Value Axis in PowerPoint 2013

Learn how to change the Major and Minor units of Value axis, and explore other Y-axis options in PowerPoint 2013.

Article Ratings:

Author: Geetesh Bajaj

Product/Version: Microsoft PowerPoint 2013
OS: Microsoft Windows 7 / 8







While learning about chart axes, you will come across two terms, Major and Minor units. These are the intervals at which the axis spaces itself -- as the name itself suggests, you can choose to space the axis at two levels: Major and Minor. Look at Figure 1, below and you can see a chart that has both Major and Minor units displayed on the Value axis. All the units pointed with blue arrows are Major units, and green arrows display Minor units.

Major and Minor Units displayed on the Value axis
Figure 1: Major and Minor Units displayed on the Value axis

PowerPoint sets the Major and Minor units on its own -- many times, this may be exactly what you need. At other times, you may want to set specific intervals for the Major and Minor units for several reasons. But before you do so, a word of caution -- do remember that any of these changes can have three implications:

  1. Values: The values that you see placed on the value axis reflect the Major units you choose. However, any changes you make to Minor units do not influence the displayed values since values of Minor unit values are not displayed on the axis.

  2. Tick Marks: The tick marks you see again change depending upon the intervals you choose for both Major and Minor units -- of course this depends upon whether you have opted to display tick marks or not. Refer to our Tick Marks on Chart Axes in PowerPoint 2013 tutorial to learn more.

  3. Gridlines: The gridlines shown change as well -- again the appearance of these gridlines will be influenced by whether you have made them visible or not.

The Major unit influences the difference between the two Major tick marks on the Value axis. Similarly, the Minor unit influences the difference between the two Minor tick marks on the Value axis. By default these values are automatically decided by the Minimum and Maximum scale values on the Value axis. Still, you can change them to suit your needs, as explained in this tutorial.

Changing Major Units of Value Axis

Follow these steps to change the Major units of the Value axis:

  1. To start with, you need a chart inserted on your slide -- for this tutorial we have selected a Column chart, as shown in Figure 2, below. As you can see, the default chart in PowerPoint 2013 shows only Primary Major Gridlines, and there are no Tick Marks.

    Chart inserted
    Figure 2: Chart inserted

  2. To see the effect of the change in Major and Minor units on your chart, turn on the Major and Minor Tick Marks on the Vertical (Value) Axis as shown highlighted in red within Figure 3, below.

    Minor Tick marks visible on the Vertical (Value) Axis
    Figure 3: Minor Tick marks visible on the Vertical (Value) Axis

  3. Now, select the Value Axis of the chart -- carefully right-click to access the contextual menu as shown in Figure 4. Within this contextual menu, chose the Format Axis option (refer to Figure 4 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 anything in the chart, and then right-click on the Value Axis.

    Format Axis option for the Vertical (Value) Axis is selected
    Figure 4: Format Axis option for the Vertical (Value) Axis is selected

  4. This opens the Format Axis Task Pane, as shown in Figure 5. Make sure that the Axis Options button is selected as shown highlighted in red within Figure 5. Note that Major unit option is set to Auto by default which is indicated by Auto option mentioned next to the Major value. Also note that Major value is set to 1.0 (highlighted in blue within Figure 5).

    Format Axis Task Pane
    Figure 5: Format Axis Task Pane

  5. Now, let us change the Major unit value. Click within the box provided with the Major option, and then type a new Major value, as shown in Figure 6 (highlighted in red). We changed the value to 2. This may change the Minor value too because it is still set to Auto option, as shown in Figure 6. The Reset button that shows up next to the Major option can be clicked if you want to get back the automatic value (Auto option).

    Major unit value changed
    Figure 6: Major unit value changed

  6. Now you can see that the value axis' Major unit values now show an interval of 2 points, as shown in Figure 7. This makes the chart look cleaner and gives it more visual breathing space (compare Figures 3 and 7).

    Major unit value change reflecting on the chart
    Figure 7: Major unit value change reflecting on the chart

  7. Save your presentation.

Changing Minor Units of Value Axis

Follow these steps to change the Minor units of the Value axis:

  1. To change the Minor unit, access the Format Axis Task Pane again (as explained in Steps 3 and 4 in the preceding section on this page).

  2. Make sure that the Axis Options button is selected as shown highlighted in red within Figure 8, below.

    Format Axis Task Pane
    Figure 8: Format Axis Task Pane

  3. Notice that the default Minor unit value is set to 0.2 (highlighted in blue within Figure 8, above). Now, click within the box provided with the Minor option, and then type a new Minor value, as shown in Figure 9 (highlighted in red). We changed the value to 0.5.

    Minor unit value changed within Format Axis dialog box
    Figure 9: Minor unit value changed within Format Axis dialog box

  4. In Figure 10 you can see that the value axis' Minor unit values now show a difference of 0.5 points. Compare Figures 3 and 10.

    Minor unit value change reflecting on the chart
    Figure 10: Minor unit value change reflecting on the chart

  5. Save your presentation.

See Also:

Change Major and Minor Units of Value Axis in PowerPoint 2011 for Mac
Change Major and Minor Units of Value Axis in PowerPoint 2010 for Windows
Change Major Unit of Y Axis in PowerPoint 2007 for Windows
Change Major Unit of Y Axis in PowerPoint 2002 and 2003 for Windows

 

PowerPoint Keyboard Shortcuts PowerPoint Keyboard Shortcuts and Sequences:
PowerPoint 2013, 2011, 2010, 2007 and 2003

Have your 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 E-Book.

PowerPoint Keyboard Shortcuts and Sequences E-book

 



comments powered by Disqus




Subscribe to Indezine
Follow Indezine

Follow Indezine on Pinterest
Share This Page
Bookmark and Share
Translate Page


Like This Page
Like This Site



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-2016, Geetesh Bajaj. All rights reserved.

since November 02, 2000