I am attempting to make a bar chart with the following type of layout.
Say the first bar totals $100, the second is $75, and the third is $60. I would love to have "step down" lines between each chart if possible. I also added a calculated expression to show the savings between the $100 and $60 as a 4th expression in the chart. Is there a way for this to show in middle (vertically) and right (horizontally) of the chart vs another bar at the bottom?
I know I can add the savings % as text in the top of the chart, but I'm not a huge fan of how that looks.
Well, it's far from ideal imho, but change the chart type from bar chart to combi chart. On the expressions tab check the options Bar and Line under Display Options. Finally select one of the Plateau (xxx) options in the dropdown box on the right of the Line option.
Personally I think you'd be better of without the bars or with a waterfall chart.