PowerPoint Tips: Create graphs with 2 Y-axes & 2 chart types

crop pictures in PowerPoint

By Ellen Finkelstein

Create graphs with 2 Y-axes & 2 chart types

How do you create a chart in PowerPoint that looks like this? It has:

  • 2 different Y-axes each with a different scale
  • 2 different chart types–column and line
  • figure 1

    I learned this feature of PowerPoint charts recently from my friend and fellow PowerPoint MVP, Echo Swinford. She is one of the top experts in the world on PowerPoint and specifically PowerPoint charts.

    Charts like this are very useful when you’re comparing 2 very different types of data. This chart is from a course of practitioners of the Transcendental Meditation technique that took place in 1993 in Washington, D.C. It compares police statistics of homicides, rapes and assaults during the course with the number of people who were on the course, which lasted 8 weeks.

    Here’s what the data looks like in Excel.

    figure 2

    Note: I found the actual chart online and estimated the numbers from the chart. I didn’t have the actual numbers, so these numbers will be slightly different from the numbers used in the study.

    Follow these steps to create a chart like this in PowerPoint 2007 or 2010:

    1. In PowerPoint, right-click off the slide, choose Layout, and choose the Title & Content layout.

    2. On the slide, click the Chart icon, which looks like a column/bar chart.

    3. In the Insert Chart dialog box, choose one of the types of chart that you want. I chose Column. Click OK.

    Steps Continued Here:

    This excerpt is shared with permission from ellenfinkelstein.com.

     794 total views,  2 views today

    (Visited 1 times, 1 visits today)

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.