Indezine Logo

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



Add Secondary Value Axis to Charts in PowerPoint 2011 for Mac

Learn how to add a secondary value axis to charts in PowerPoint 2011 for Mac. A secondary value axis can be helpful if you are showing two types of data in the same chart.


Author:

Product/Version: PowerPoint 2011 for Mac

OS: Mac OS X



Learn PowerPoint

Explore and understand Microsoft Locale IDs.



Sometime, one value axis for a chart is not enough! Of course that observation is only true if your data demands a second axis. Our example data for this tutorial pertains to the average temperature and rainfall in London across the 12 calendar months of a year. Figure 1 below, shows a chart that depicts this data from January to December. The temperature is depicted in degrees celsius and the rainfall is in millimeters. What you should note carefully is that the value range of temperature spans between 0 to 12 (approximately) whereas the range for rainfall is between 30 and 70. A chart that results from this data doesn't live up to the comparison, it's almost like comparing apples and oranges. Yes, we are comparing items that cannot be compared!

Chart with two Data Series
Figure 1: Chart with two data series

To help your audience comprehend this data better, you could create two charts, but that’s an overkill since there’s a better, more elegant solution. You should span this data on two value axes within the same chart: one for the temperature and the other for the rainfall.

Axes in PowerPoint

To learn more about axes, refer to our Axes in PowerPoint Charts tutorial.

Follow these steps to add a secondary value axis in PowerPoint 2011 for Mac:

  1. Open your presentation and navigate to the slide that contains your chart. Within the chart, select the series to which you want to add a second value axis. Right-click (or Ctrl+click) this series to access the contextual menu, as shown in Figure 2, below. From the contextual menu, choose the Format Data Series option (refer to Figure 2 again).
  2. Format Data Series option selected
    Figure 2: Format Data Series option selected
  3. Doing so summons the Format Data Series dialog box that you can see in Figure 3, below. In this dialog box, select the Axis option within the sidebar. Next select the radio button in front of the Secondary axis option, as shown highlighted in red within Figure 3.
  4. Secondary axis option selected for one of the series
    Figure 3: Secondary axis option selected for one of the series
  5. This step adds a secondary value axis that maps your selected series, as shown in Figure 4, below. Note that axis labels on both the value axes show different numbered ranges. The primary value axis displays minimum and maximum values between 0.0 and 14.0 and the secondary value axis spans a completely different range between 0 and 80.
  6. Secondary Value Axis added
    Figure 4: Secondary value axis added
  7. We might have solved the problem of comprehending the actual values better now, but we have a new problem to solve! As you can see in Figure 4 above, one data series is overlapping the other. Columns depicting rainfall are completely hiding most of the columns representing the average temperature
  8. To solve this problem, you need to change the chart type of any one of the series. Select the series that you want to change the type of, and right-click (or Ctrl+click) to access the context menu, as shown in Figure 5, below. From the context menu, choose the Change Series Chart Type option (refer to Figure 5 again).
  9. Change the Chart Type of selected Series
    Figure 5: Change the chart type of selected series
  10. Doing so activates the Charts tab on the Ribbon and makes all Chart Types visible as shown in Figure 6, below. Choose a new chart type for the selected series and click on it. We chose the Marked Line chart type (refer to Figure 6 again).
  11. Choose a new chart type for the selected Series
    Figure 6: Choose a new chart type for the selected series
  12. Contextual Tabs

  13. The Chart Layout and Format are contextual tabs. These tabs are special tabs in the Ribbon that are not visible all the time. They only make an appearance when you are working with a particular slide object which can be edited using special options.
  14. This action changes the selected series to the new chart type. In Figure 7, below you can see that the series representing rainfall has changed to a Marked Line.
  15. Chart type changed for the selected Series
    Figure 7: Chart type changed for the selected series
  16. Creating a combination chart of this type with two series makes your data appear so much better, and it also ends up being so much easier on the eye for your audience. You cannot compare apples and oranges, but they can still co-exist!
  17. Look closely at Figure 7 again, and you will realize that there’s no easy way to identify if a particular series uses the primary or the secondary axis. With just two series, this is an easy problem to solve. We just changed the font color of the axes labels to match the color of the series as shown in Figure 8, below (compare with Figure 7).
  18. Font color changed for the Secondary Axis labels
    Figure 8: Font color changed for the secondary axis labels
  19. Save your presentation.

See Also:

Chart Axes: Add Secondary Value Axis to Charts (Glossary Page)

Add Secondary Value Axis to Charts in PowerPoint 2013 for Windows

You May Also Like: Analysis Feature in WeCompress: Conversation with Mike Power | Pound PowerPoint Templates


Popular Posts

Shapes
Learn how you can create and manipulate shapes in PowerPoint -- knowledge of working with shapes is significant because they are the building blocks of creativity in PowerPoint.

Insert Picture from the Office ClipArt Collection in PowerPoint 2013
Learn how to insert picture using Office ClipArt in PowerPoint 2013.

Snow Effect in PowerPoint
Create a snow fall effect inside PowerPoint using animation techniques.

PowerPoint Transitions: Curtains
Explore the Curtains transition effect in PowerPoint.



Feature List 01 (Layout with Tabs)

The Feature List Layout comprises three sample PowerPoint presentations: one each to create a visual list for 4 features, 5 features, and 6 features. These work great when you have too much information to fit within one slide. This solution lets you use multiple slides, but the visual result is still that of one single slide!

Buy and Download Feature List 01 (Layout with Tabs) for $4.99+ (671 kb)

This is the original page. An AMP (Accelerated Mobile Page) version of this page is also available for those on mobile platforms, at Add Secondary Value Axis to 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.