Indezine Logo

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

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

Highlight negative values in a chart by using the Invert if Negative option in PowerPoint 2010 and 2007 for Windows.


Product/Version: PowerPoint 2010 and 2007 for Windows

OS: Windows XP and higher

If your chart has negative value PowerPoint by default uses the same fill color for negative values in any chart (see Figure 1) -- you can anyhow override that with a convenient Invert if Negative option that we explored towards the end of the Changing Fills and Outlines of Charts 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.

  1. Select the data series by clicking on it (see Figure 2). Alternatively you can select the data series from the chart elements dropdown list.

    Selected chart element (data series)
    Figure 2: Selected chart element (data series)
  2. Activate the Chart Tools Layout tab of the Ribbon. Towards the extreme left of the Ribbon tab, make sure that you have the correct data series selected -- then click the Format Selection button (see Figure 3).

    Format Selection button
    Figure 3: Format Selection button
  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 Format Data Series dialog box, select the Fill tab on the left pane and on the right pane under Fill options choose Invert if Negative (highlighted in red), as shown in Figure 5 and click Close 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.

    Invert if Negative
    Figure 5: Invert if Negative

    Invert if Negative in PowerPoint 2010
    Figure 6: Invert if Negative in PowerPoint 2010
  5. This will change the color of the negative figure column to white, as you can see in Figure 7.

    Negative figure column
    Figure 7: 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 in PowerPoint 2007 and 2010 Charts tutorial explains more.
  6. 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 2002 and 2003 for Windows

Jigsaw Graphics for PowerPoint

Here are 10 jigsaw graphics containing different shapes. These graphics are available in both black and white and are contained within separate sample presentations that you download. Additionally, these jigsaw graphics are vector shapes, so you can easily edit them within your Microsoft Office program by changing fills, lines, and effects or even applying Shape Styles.

Download and use these Jigsaw Graphics in your slides for just $4.99+

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.