Indezine Logo




Change Major and Minor Units of Value Axis in PowerPoint 2007 for Windows

Change major and minor units of the value axis in PowerPoint 2007 for Windows. We also explore other value axis options.


Author:

Product/Version: PowerPoint 2007 for Windows

OS: Microsoft Windows XP and higher



Learn PowerPoint

Explore the difference between UPPERCASE and All Caps in PowerPoint.



The significance of any chart lies in its ability to visually represent complex data as a trend that an audience can easily grasp. So if you create a complex chart with too much detail, you might be ironically creating confusion out of simplicity, even if you are not aware that you are doing this! One of the easiest ways in which you can make your chart look simpler and less intimidating is by using fewer major units in the Y axis, and if that sounds like something that's difficult for you to understand, then stop worrying and start following this easy tutorial. This tutorial is for PowerPoint 2007 and will also work in PowerPoint 2010 for Windows, users of PowerPoint 2002 and 2003 can follow this similar tutorial.

If you want, you can follow this tutorial with us, all you need is a slide with the default column chart inserted in PowerPoint 2007 or 2010.

Follow these steps to change major unit of Y axis in PowerPoint 2007 or 2010.

  1. Select the chart within PowerPoint slide, as shown in Figure 1, below.
  2. Chart editing mode
    Figure 1: Chart editing mode
  3. Now, click on the Vertical Value Axis (the vertical line towards the left of the plot area), as shown in Figure 2, below.
  4. Vertical Value Axis
    Figure 2: Vertical value axis
  5. Activate the Chart Tools Layout tab of the Ribbon. Towards the extreme left of the Ribbon tab, make sure that you have selected the Vertical Value Axis, then click the Format Selection button as shown in Figure 3, below.
  6. Format selection
    Figure 3: Format selection
  7. Doing so summons the Format Axis dialog box, as shown in Figure 4, below. Select the Axis Options tab from the left pane, and you'll find the options explained below in the right pane of the dialog box.
  8. Format Axis
    Figure 4: Format Axis
  9. Within the Axis Options tab of the dialog box, you'll find these options:
  10. Minimum

  11. Set the minimum value for the axis.
  12. Maximum

  13. Set maximum value for the axis.
  14. Major unit

  15. Change the value to alter major tick marks on the value axis.
  16. Minor unit

  17. Change the value to alter minor tick marks on the value axis.
  18. Values in Reverse Order

  19. Display the largest value at the bottom of the axis and the smallest at the top.
  20. Logarithmic Scale

  21. Displays the values in a logarithmic, rather than an arithmetic relationship.
  22. Display units

  23. Choose from hundreds, thousands, millions, billions, and trillions. You can also set this as None.
  24. Major tick mark type

  25. Select to define the appearance of tick marks on the specified axis. You can choose in between outside, inside, and cross.
  26. Axis labels

  27. Here you can place the axis label to. Next to axis (default), high or low.
  28. Horizontal axis crosses

    Automatic

  29. This option, if selected follows the default setting.
  30. Axis value

  31. Here you can set the axis cross value.
  32. Maximum axis value

  33. This option takes the highest value and applies the changes.
  34. Now choose the Fixed radio button in Major unit, and enter the value in the text box, such as 4 (see Figure 5).
  35. Major unit
    Figure 5: Major unit
  36. Note: Choose the Major unit value based on the highest value you have for the Vertical Value Axis.
  37. When done, click the Close to get back to the chart.
  38. Figure 6, shows that the Y-axis major unit values now show a difference of 4 points. This makes the chart look cleaner and gives it more visual breathing space.
  39. Y-axis values
    Figure 6: Y-axis values
  40. Save your presentation.

See Also:

Chart Axes: Change Major and Minor Units of Value Axis (Glossary Page)

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

You May Also Like: Beyond Bullet Points 4th Edition: Conversation with Cliff Atkinson | Newspaper PowerPoint Templates


Popular Posts

Creating Anchor Points for Connectors in PowerPoint 2010 for Windows
Creating Anchor Points for Connectors in PowerPoint 2010 for Windows
Learn how to create Anchor Points for connectors in PowerPoint 2010.

Working With Slide Numbers in PowerPoint 2016 for Windows
Working With Slide Numbers in PowerPoint 2016 for Windows
Learn how to add Slide Numbers on slides and Masters and more tricks on making them work to your will in PowerPoint 2016 for Windows.

Texture Fills for Slide Backgrounds in PowerPoint 2013 for Windows
Texture Fills for Slide Backgrounds in PowerPoint 2013 for Windows
Use texture fills for slide backgrounds in PowerPoint 2013 for Windows.

Adding More Guides in PowerPoint 2016 for Windows
Adding More Guides in PowerPoint 2016 for Windows
Learn how to add more guides in PowerPoint 2016 for Windows.



Feature List 01 (Layout with Tabs)

The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features. These work great when you have too much information to fit within one slide. This solution lets you use multiple slides, but the visual result is still that of one single slide!

Buy and Download Feature List 01 (Layout with Tabs) for $4.99+ (671 kb)

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Change Major and Minor Units of Value Axis in PowerPoint 2007 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.