Home | Products | PowerPoint | PowerPoint Tutorials | Charts

Using the Invert if Negative Option within Charts in PowerPoint 2013

Learn how you highlight the negative values in a chart by using the Invert if Negative option within a chart in PowerPoint 2013.

Add Your Ratings!:

Author:

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







If your chart has negative value then PowerPoint by default uses the same fill color for negative values in any chart as you can see in the sample chart within Figure 1. You can override this nature with the Invert if Negative option that we mentioned towards the end of the Changing Fills and Outlines of Chart Elements tutorial.

Chart with negative figures
Figure 1: Chart with negative figures

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.

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:

  1. Select the Data Series in PowerPoint 2013 by clicking once on any of the columns, or within the chart elements drop-down list -- right-click to bring up the contextual menu as shown in Figure 2. Within this contextual menu, select the Format Data Series option (refer to Figure 2) again. If you do not get the Format Data Series 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 any series (for example, a single column within a column chart).

    Format Data Series option
    Figure 2: Format Data Series option

  2. This will bring up the Format Data Series Task Pane, as shown in Figure 3. Within this Task Pane, make sure that Fill & Line button is selected (highlighted in red within Figure 3). Within this tab, select the Invert if negative check-box, as shown highlighted in blue within Figure 3.

    Format Data Series Task Pane
    Figure 3: Format Data Series Task Pane

  3. This will change the color fill of the negative figure column to white, as you can see in Figure 4.

    Negative figure column
    Figure 4: Negative figure column

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


  4. Save your presentation.

See Also:

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
Charts in PowerPoint, Using the Invert if Negative Option 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