15 responses

  1. Valary
    April 25, 2012

    Hi Ellen,

    I love this trick and I frequently use combined charts like this.

    The next step I would usually take (when possible) is to adjust the scale on one or both axes to have the same number of divisions on each side. In your example there are nine markers on the primary axis and six on the secondary which causes the tick marks for the secondary axis to stick out at seemingly random places (based on the gridlines) and distracts from the clarity of the chart. I find simpler construction is visually easier to view and process.

    Valary

    • Ellen
      April 25, 2012

      Valary, that’s an excellent point!

  2. Sergio Cebrian
    June 12, 2012

    is there a way, to make that 2 charts share same DATA in a powerpoint chart? (but in the same file and not by linking to an external excel file)

    :D

    btw very useful post :D

    • Ellen
      June 12, 2012

      I’m not sure I understand. Would one chart have one piece of the data and another have another piece?

  3. Susan Hope
    September 13, 2012

    Exactly what I was looking – very useful!!!!

  4. Colin Z
    October 31, 2012

    Wonderful! Thanks for the detailed instructions! This is exactly what I was looking for!

    • Ellen
      October 31, 2012

      Glad to help!

  5. eEli
    January 10, 2013

    Great help. Thanks. Is there a way I can put the exact numerical value at the end of each bar?

    • Ellen
      January 10, 2013

      Yes,using a data label. I can’t give you specific instructions without knowing which version of PowerPoint you use, but data labels aren’t hard to find.

  6. Eli
    January 10, 2013

    Thanks Ellen! That was so quick and simple once I new what to call it.

  7. Tina
    April 8, 2013

    Is there a way to have more than 2 y-axes? In particular, I am trying to use 3 horizontal bars but each bar uses a different scale, the 1st one being percentage, the 2nd being a number range and the 3rd being dollar range… is this even possible in the same graph? Thanks!

  8. Ellen Finkelstein
    April 9, 2013

    Tina,
    I don’t think so. Perhaps you can put one on top of the other?

  9. Mary Jane
    November 17, 2014

    Thank you! I have been trying to figure this out for days!!!!

  10. Mehul
    December 2, 2014

    Thanx a lot for this tip. Has been very helpful

  11. Bobby Helpful
    December 30, 2014

    Tina, if you want three series of differently-scaled data in a single graphic, try using a 3D chart maybe. Not sure how scaling would work though –
    Probably you’d have to re-scale manually, produce new data series: e.g. %s, #/55, $/300… whatever gets all three sets of numbers into same range.
    Then ‘hand-make’ new axes (showing ‘true’ original value-scales for # and $) using text boxes) All a bit approximate but its do-able!

Leave a Reply

 

 

 

Back to top
mobile desktop