Home | Products | PowerPoint | PowerPoint Tutorials | Charts

Charts in PowerPoint, Using the Invert if Negative Option in PowerPoint 2002 and 2003

Author: Geetesh Bajaj

Product/Version: PowerPoint 2002 and 2003

Date Created: March 30th 2010
Last Updated: March 30th 2010

Excerpt/Capsule: Learn how you highlight negative values in a chart by using the "Invert if Negative" option of a data series in a chart within PowerPoint 2002 or 2003.

In an ideal world, we would like to have charts that had all positive values -- but sometimes growth rates may plummet and you might end up seeing negative values in your charts, as shown in Figure 1.

Chart with negative figures
Figure 1: Chart with negative figures

Now by default, PowerPoint uses the same color fills for negative values in any chart (again, see Figure 1 above) -- although you can override that with a convenient Invert if Negative option that we explored towards the end of the Changing Fills and Outlines of Charts tutorial. In this tutorial, we'll cover everything right from scratch all over again -- so feel free to continue reading this page for now.

Note: The Invert if Negative option is only enabled for column, bar, cylinder, cone and pyramid chart types. The pie and area chart types do not have this option as they don't plot negative figures.

  1. You must have a chart that has negative values, as shown in Figure 2. Double-click the chart and then select the data series. If you have trouble selecting the data series, you can select any chart object from the Standard toolbar in chart editing mode.

    Select chart object
    Figure 2: Selected chart object

  2. With the data series selected, choose the Format | Selected Data Series menu option, as shown in Figure 3.

    Selected Data Series
    Figure 3: Selected Data Series

  3. This summons the Format Data Series dialog box, as shown in Figure 4.

    Format Data Series
    Figure 4: Format Data Series

  4. Within the Patterns tab of the dialog box, choose Invert if Negative option (highlighted in red) and click OK. This will change the color of the negative figure column to white, as you can see in Figure 5. Most of the time, you don't want the negative color to be white  --  we address this issue in our Changing Color for Negative Data Series in PowerPoint Charts tutorial.

    Negative figure column
    Figure 5: Negative figure column

    Note: You can change the color of your negative figure column to something other than white -- our Changing Color for Negative Data Series in PowerPoint Charts tutorial explains more.

  5. Save your presentation.

See Also:

Using the Invert if Negative Option within Charts in PowerPoint 2013 for Windows
Charts in PowerPoint, Using the Invert if Negative Option in PowerPoint 2011 for Mac
Charts in PowerPoint, Using the Invert if Negative Option in PowerPoint 2007 and 2010 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-2018, Geetesh Bajaj. All rights reserved.

since November 02, 2000