Home | Products | PowerPoint | PowerPoint Tutorials | Charts

Change Major and Minor Units of Value Axis in PowerPoint 2011 for Mac

Author: Geetesh Bajaj

Product/Version: PowerPoint 2011
OS: Mac OS X

Date Created: January 23rd 2013
Last Updated: January 23rd 2013


Excerpt/Capsule: Learn how to change the Major and Minor units of Value axis, and explore other Y-axis options in PowerPoint 2011 for Mac.






Major and Minor units 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'll see a chart that has both Major and Minor Units displayed on the Value axis. All the units pointed with blue arrows are Major, 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

By default, 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 your own intervals for the Major and Minor units. 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 units are not shown 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 2011 for Mac 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.

Follow these steps to learn more:

  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 shows only Major units for both tick marks and gridlines. No Minor units are represented here.

    Chart inserted
    Figure 2: Chart inserted

  2. To see the effect of the Minor units on your chart, turn on the Minor tick marks on the Vertical (Value) Axis as shown in 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 click on the Vertical (Value) Axis (the axis towards the left of the plot area) to select it, as shown in Figure 4.

    Vertical (Value) Axis selected
    Figure 4: Vertical (Value) Axis selected

  4. Right click (Ctrl+click) the Vertical (Value) Axis to bring up the context menu that you see in Figure 5 -- select the Format Axis option (refer to Figure 5 again).

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

  5. This summons the Format Axis dialog box. Make sure that the Scale option is active on sidebar, as shown in Figure 6. As you can see, all Vertical axis scale options are set to Auto by default.

    Format Axis dialog box
    Figure 6: Format Axis dialog box

  6. To change the Major unit value, deselect the Major unit check-box to take it off Auto mode, and enter the new value in the box (highlighted in red within Figure 7). We changed the value to 2.

    Major unit value changed
    Figure 7: Major unit value changed

    Note: Choose the Major unit value based on the highest value you have for the Vertical (Value) Axis.


  7. When done, click the OK button to apply the change and get back to the chart. In Figure 8 you can see that the value axis' Major unit values now show an interval of 2 points. This makes the chart look cleaner and gives it more visual breathing space. Compare Figures 2 and 8.

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

  8. To change the Minor unit, access the Format Axis dialog box again (see Steps 3 and 4) -- make sure that the Scale option is active on sidebar as shown in Figure 9. As you can see in Figure 9, the default Minor unit value is set to 0.2 (highlighted in red within Figure 9).

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

  9. Now, deselect the Minor unit check-box to take it off Auto mode, and add the new required value in the box. We changed the value to 0.1, as shown highlighted in red within Figure 10.

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

  10. When done, click the OK button to apply the change and get back to the chart. In Figure 11 you can see that the value axis' Minor unit values now show a difference of 0.1 points. Compare Figures 3 and 11.

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

  11. Save your presentation.

See Also:

Change Major and Minor Units of Value Axis in PowerPoint 2013 for Windows
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

 

Office 2008 for Mac All-in-One For Dummies Office 2011 for Mac All-in-One For Dummies

If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon.

This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.

Check the book on Amazon.com...




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