8 Replies Latest reply on Jul 21, 2016 3:11 PM by Derek Wong

    Help with percentages on stacked bar chart

    Melissa Fanucci

      Hello!

      I'm having a hard time figuring out how the percentages showing on my bar chart are being calculated (see attached workbook,  tab "NEXUS vs CAR"). My goal is to recreate this graph:

      chart.jpg

      But I'm having trouble with a) figuring out the right way for the percentage to be calculated (I think its basing its number on all possible modes, not just the two selected for this graphic), and how to have northbound and southbound bars next to each other.

       

      Any help, as always, would be greatly appreciated!

       

      Thanks,

       

      Melissa