Indezine Logo




Using the Invert if Negative Option for Charts in PowerPoint 2011 for Mac

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


Author:

Product/Version: PowerPoint 2011 for Mac

OS: Mac OS X



Learn PowerPoint

Presentation Management 05: Why Is It Important Now



Does your chart has any data with negative values? PowerPoint by default uses the same fill color for negative values as is used for positive values. Look at Figure 1, below where we have used solid fills for our columns representing a series. Of course, you can override this nature of PowerPoint using the Invert if Negative option, that we last explored at the end of our Changing Fills and Outlines of Charts tutorial. In this tutorial, let us explore this option further.

Chart with negative figures
Figure 1: Chart with negative values

Where is the Invert if Negative Option?

The Invert if Negative option is only available 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 inserted a chart on your slide that has negative values, as shown in Figure 1, above.

Follow these steps to use the Invert if Negative option in PowerPoint 2011 for Mac:

  1. Select the data series including negative values 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. Chart element (data series) with negative value selected
    Figure 2: Chart element (data series) with negative value selected
  3. With the data series selected, select either the Chart Layout or the Format tabs of the Ribbon as shown in Figure 3, below. With any of these tabs selected, locate the Current Selection group, that you can see in Figure 3 towards the extreme left. Within this group, make sure that the Chart Elements drop-down list, as shown highlighted in red within Figure 3 is displaying the name of the selected chart element. Then, click the Format Selection button below it as shown highlighted in blue within Figure 3.
  4. Format Selection button to be clicked with the correct chart element selected
    Figure 3: Format Selection button to be clicked after the proper data series is selected
  5. This action summons the Format Data Series dialog box. Make sure that the Fill option is selected in the sidebar, as shown in Figure 4, below.
  6. Format Data Series dialog box
    Figure 4: Format Data Series dialog box
  7. Make sure the Solid tab is selected and then select the Invert if Negative check box, as shown highlighted in red within Figure 4, above. Then, click the OK button. This action will change the color of the negative figure column to white, as you can see in Figure 5, below. Compare Figures 5 and 2.
  8. Fill of the Negative figure column changed to white
    Figure 5: Fill of the negative figure column changed to white
  9. Can I Change the Negative Color to Something Other than White?

  10. Want to change the color fill of the negative figure column from white to some other color? Refer to our Changing Color for Negative Data Series of Charts in PowerPoint 2011 for Mac tutorial.
  11. In the above example, we have used the solid color as fill for the data series. If the fill is a gradient, then the result of selecting the Invert if Negative check box will be little different. Figure 6, below shows a chart with gradient fill used for the data series before applying Invert if Negative.
  12. Chart with gradient fill applied to the columns (data series)
    Figure 6: Chart with gradient fill applied to the columns (data series)
  13. If you select the Invert if Negative check box for this chart, the result will look like something that you can see in Figure 7, below. Compare the third column of the chart in Figures 6 and 7.
  14. Negative figure column with gradient fill inverted
    Figure 7: Negative figure column with gradient fill inverted
  15. As you can see in Figure 7, above the gradient fill of the column with negative figure has been inverted.
  16. Save your presentation.
Note: Selecting the Invert if Negative check box won't make any difference to the negative figure columns if the picture or the texture fill has been used in them.

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 2007 for Windows
Using the Invert if Negative Option for Charts in PowerPoint 2003 and 2002 for Windows

You May Also Like: Add Humor to Your Presentation | Dry Fruits (General) PowerPoint Templates


Popular Posts

Add Pattern Fills to Shapes in PowerPoint 2010 for Windows
Add Pattern Fills to Shapes in PowerPoint 2010 for Windows
Add pattern fills to shapes in PowerPoint 2010 for Windows.

Gradient Fills for Text in PowerPoint 2013
Gradient Fills for Text in PowerPoint 2013
Learn how to add gradient fills to selected text in PowerPoint 2013.

Formatting Outlines for Shapes (Dashes) in PowerPoint 2013 for Windows
Formatting Outlines for Shapes (Dashes) in PowerPoint 2013 for Windows
Learn how to apply the dash attribute to shape outlines in PowerPoint 2013 for Windows.

Change the Unit of Measurement in Windows 10
Change the Unit of Measurement in Windows 10
Learn how to change the unit of measurement from US to Metric, and vice versa in Windows 10.



Ebook PowerPoint Keyboard Shortcuts

PowerPoint Keyboard Shortcuts and Sequences Ebook

PowerPoint 365, 2019, 2016, 2013, 2011, 2010, 2007 and 2003 for Windows

PowerPoint 365, 2019, 2016 and 2011 for Mac

PowerPoint for the Web on Windows and Mac

Have you 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 2011 for Mac.


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.