Changing Color for Negative Data Series of Charts in PowerPoint 2011 for Mac
Author: Geetesh Bajaj
Product/Version: PowerPoint 2011
OS: Mac OS X
Date Created: December 28th 2012
Last Updated: December 28th 2012
Excerpt/Capsule: Learn how to change the default color of negative value data series to a color of your choice in PowerPoint 2011's charts.
When you select the invert if negative option for a chart that has any negative data values in a series, you end up seeing those negative series with an inverted gradient fill (see Figure 1 later on this page). Since there appears little difference between the gradient fill used for positive and negative values as far as appearance is concerned, you may wish your negative series to show in a solid color that contrasts with the positive series. This color can be red (or any other color). In this tutorial, let us learn how you can do so in PowerPoint 2011.
Follow these steps to change the color fill of any negative data series in your PowerPoint 2011 charts:
- Select the chart that has data with negative values, and for which you have already selected the invert if negative option, as shown in Figure 1. Select the data series by clicking on it (again see Figure 1) -- alternatively you can select the data series from the Chart elements drop-down list.
Figure 1: Chart with Invert if Negative option selected
- With the chart series selected, select either the Chart Layout or the Format tab of the Ribbon that you can see in Figure 2. Within any of these tabs, you will find the Current Selection group towards the extreme left as you can see in Figure 2. Within this group, make sure that the Chart Elements drop-down list (highlighted in red within Figure 2) is displaying the name of the selected data series. Then, click the Format Selection button below it (highlighted in blue within Figure 2).
Figure 2: Format Selection button to be clicked with the correct data series selected
- This summons the Format Data Series dialog box -- make sure you have the Fill option selected in the sidebar and the Solid tab of this dialog box active -- you should see the same options as displayed in Figure 3, below. At this point, we are assuming that you have already selected the Invert if Negative option (highlighted in red within Figure 3).
Figure 3: Format Data Series dialog box
- To set a different color for a negative value series, we need to set foreground and background color options. This involves an ironical detour to the Pattern tab of Format Data Series dialog box (highlighted in red within Figure 4). Choose the pattern named 90% (highlighted in blue within Figure 4) -- this activates all options within the Pattern tab, as shown in Figure 4.
Figure 4: Options within Pattern tab
- Now, chose a solid color from the Background color gallery that you can see in Figure 5 -- this color will be used as a fill for negative values. We selected red because it goes well with the negative concept (see Figure 5). Click OK to go back to your chart with the new fills.
Figure 5: Background color selected for negative values
- Figure 6 shows how the chart looks. Now, we can optionally get rid of the pattern fills applied and change the foreground color.
Figure 6: Columns filled with Pattern fill
- Again, summon the Format Data Series dialog box -- make sure the Fill option is selected in the sidebar, then select the Solid tab. Open the Color gallery and select any other color for the positive values as shown in Figure 7. Do remember that the fill for your data series will no longer be a gradient -- and will change to a solid fill. Click OK to apply the changes and get back to the chart.
Figure 7: Solid fill being applied
- Figure 8 shows the final chart which has distinctly different colors for positive and negative data values. As you can see in Figure 8, our sample chart has only one data series -- and if you need to have more negative values in the same series, they will continue to show in the color you chose to display negative values. However, if you add another series to the same chart -- and only if that series contains negative values -- then that particular series will have to be similarly formatted for negative values using the steps previously explained on this page.
Figure 8: Chart with changed colors
- Save your presentation.
Changing Color for Negative Data Series of Charts in PowerPoint 2013 for Windows
Changing Color for Negative Data Series in PowerPoint 2007 and 2010 Charts for Windows
Changing Color for Negative Data Series in PowerPoint 2002 and 2003 Charts for Windows
If you liked this tutorial, do look at this book, authored by Geetesh Bajaj and James Gordon.
This book is the single most comprehensive content for Microsoft's latest Office suite offering for Mac users.
Check the book on Amazon.com...