Indezine Logo

  This is the print version of this page. All content is copyright Indezine.com 2000-2021.



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

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


Author:

Product/Version: PowerPoint 2013 for Windows

OS: Microsoft Windows 7 and higher



Learn PowerPoint

Presentation Management 07: From One-and-Done to Enterprise Assets



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, below. 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 for Windows 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, below. 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).
  2. [an error occurred while processing this directive]
    Figure 2: Format Data Series option
  3. This action will bring up the Format Data Series Task Pane, as shown in Figure 3, below. Within this Task Pane, make sure that Fill & Line button is selected, as shown highlighted in red within Figure 3. Within this tab, select the Invert if negative check-box, as shown highlighted in blue within Figure 3.
  4. [an error occurred while processing this directive]
    Figure 3: Format Data Series Task Pane
  5. This will change the color fill of the negative figure column to white, as you can see in Figure 4, below.
  6. [an error occurred while processing this directive]
    Figure 4: Negative figure column
  7. 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.
  8. 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 2011 for Mac
Using the Invert if Negative Option for Charts in PowerPoint 2007 for Windows
Using the Invert if Negative Option for Charts in PowerPoint 2003 and 2002 for Windows

You May Also Like: Presentation Skills: Conversation with Payam Bahrampoor | Fig (Dry Fruit) PowerPoint Templates


Popular Posts

PowerPoint Tutorials, Articles and Reviews
Tutorials, reviews, articles and templates for Microsoft PowerPoint and other presentation software.

PowerPoint Templates
Find over 6000 PowerPoint templates in thousands of categories and all colors—from a trusted PowerPoint template resource for 20 years.

Create Animated GIFs from PowerPoint Slides
Explore ways to create animated GIFs from PowerPoint slides.

PowerPoint Tutorials
These PowerPoint tutorials have many screen shots that show you exactly what you see in your computer!



Pictures in Presentations

Is a picture is worth a thousand words? You probably have heard this adage so often that we decided not to repeat this phrase throughout this book! Now here’s some more info: the human brain uses a larger part of its area to store visual information rather than textual content. And that’s possibly because a picture describes so much more than text.

Go and get a copy of our Pictures in Presentations 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 2013 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.