How to control the bars in a stacked bar chart? I want the very top to be the total # of widgets and the top of the smaller bar to be a portion of that total.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
To be more clear: In the Opportunities Table we track the number of proposals submitted each month and the number of those proposals that we won. When stacked, I want the very top of the bars to line up with the total # of proposals submitted and the top of the smaller section to line up with the # of proposals won. I don't want the totals to be combined on the same scale.

For example: In March, we submitted 16 proposals and we won 12 of them. The very top of the stack needs to line up 16, NOT 28 (16 + 12 = 28) , and the top of the lower bar needs to line up with 12. See attached screenshot for visual clarity.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Scott

Scott

  • 314 Points 250 badge 2x thumb
As it is, I don't think that with a native stacked bar chart this is do-able.  

However, I had to do something similar with Margin and Price before and ended up using a Line chart instead.  You would set it up just as you would for a stacked bar, X-Axis being Date/Month and you Y-Axis values being # of Opportunities and # of Won Opportunities.  Keep both Y-Axis items on the primary axis to keep them on the same # scale.
Photo of Robin CC

Robin CC

  • 200 Points 100 badge 2x thumb
Thanks Scott.  A line chart will work good.  I never noticed that subtle difference between line and bar charts before.
Photo of Scott

Scott

  • 314 Points 250 badge 2x thumb
Glad to help!