Indezine Logo




Using the Invert if Negative Option for Charts in PowerPoint 2007 for Windows

Highlight negative values in a chart in PowerPoint 2007 for Windows. This result can be achieved by using the Invert if Negative option.


Author:

Product/Version: PowerPoint 2007 for Windows

OS: Microsoft Windows XP and higher



Learn PowerPoint

Presentation Management 06: Empowering Presenters



If your chart has negative values, then PowerPoint uses the same fill color for negative values as you can see in the sample chart within Figure 1, below. Fortunately, you can override this color choice with a convenient Invert if Negative option that we briefly explored towards the end of the Changing Fills and Outlines of Charts tutorial.

Chart with negative figures
Figure 1: Chart with negative values

Where is the Invert if Negative Option?

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.

To use the Invert if Negative option you must have a chart that has negative values, as shown in Figure 1, above. Then, follow these steps to use the Invert if Negative option in PowerPoint 2007 for Windows:

  1. Select the data series by clicking on it as shown in Figure 2, below. Alternatively you can select the data series from the chart elements drop-down list.
  2. Selected chart element (data series)
    Figure 2: Selected chart element (data series)
  3. Activate the Chart Tools Layout tab of the Ribbon found towards the extreme right of the Ribbon. Make sure that you have the correct data series selected. Then, click the Format Selection button as shown in Figure 3, below.
  4. Format Selection button
    Figure 3: Format Selection button
  5. This action summons the Format Data Series dialog box, as shown in Figure 4, below.
  6. Format Data Series
    Figure 4: Format Data Series
  7. Within the Format Data Series dialog box, select the Fill tab on the sidebar. Next, below the Fill options, check the Invert if Negative box, as shown highlighted in red within Figure 5, below. Then, click the Close button to get back to the chart. Figure 6 shows you the same Format Data Series dialog box with Invert if negative option selected in PowerPoint 2010 for Windows.
  8. Invert if Negative
    Figure 5: Invert if negative
  9. Invert if Negative in PowerPoint 2010
    Figure 6: Invert if negative in PowerPoint 2010
  10. Doing so will change the color fill of the negative figure column to white, as you can see in Figure 7, below.
  11. Negative figure column
    Figure 7: Negative figure column
  12. Can I Change the Negative Color to Something Other than White?

  13. You can change the color fill of your negative figure column to something other than white. Our Changing Color for Negative Data Series in PowerPoint 2007 and 2010 Charts tutorial explains more.
  14. Save your presentation.

See Also:

Advanced Chart Techniques: Using the Invert if Negative Option for Charts (Glossary Page)

Using the Invert if Negative Option for Charts in PowerPoint 2013 for Windows
Using the Invert if Negative Option for Charts in PowerPoint 2011 for Mac
Using the Invert if Negative Option for Charts in PowerPoint 2003 and 2002 for Windows

You May Also Like: Morph in PowerPoint: Conversation with Lauren Janas | Dates PowerPoint Templates


Popular Posts

Changing Location of Slide Numbers in PowerPoint 2010
Changing Location of Slide Numbers in PowerPoint 2010
Learn how to change location of slide numbers in PowerPoint 2010.

Text Alignment within Table Cells in PowerPoint 2013 for Windows
Text Alignment within Table Cells in PowerPoint 2013 for Windows
Learn about the options for text alignment within Table cells in PowerPoint 2013 for Windows.

Keyboard Shortcuts for PowerPoint 2011 for Mac
Keyboard Shortcuts for PowerPoint 2011 for Mac
Explore keyboard shortcuts in PowerPoint 2011 for Mac.

Insert Video from Facebook in PowerPoint 2016 for Windows
Insert Video from Facebook in PowerPoint 2016 for Windows
Learn how to insert video from your Facebook account in PowerPoint 2016 for Windows.



PowerPoint Keyboard Shortcuts and Sequences:
PowerPoint 2016, 2013, 2011, 2010, 2007 and 2003 for Windows
PowerPoint 2016 and 2011 for Mac
PowerPoint Online for Windows and Mac

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 ebook.

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Using the Invert if Negative Option for Charts 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.