The image above is a mock up from PowerPoint. I can get the chart to work in a Block Chart, Gauge or Bar Chart, but I can't get the text to do what I want. I would like to see the values and the expression label in the chart.
Any suggestions are appreciated. I am guessing the answer is simple and I am just missing it.
I would also like to keep the green on the left and the red on the right if possible.
Thanks in advance for your help.
Okay, so that works pretty well. Even when I have a small about on the negative side it looks good.
Not so much when I add a third status type.
Looks good when it is even:
But uneven doesn't look great:
Maybe I didn't quite understand what you were describing.
Yer that is what i was meaning like you say it isn't great once you start having more than two. I haven't found a good way of making them more dynamic, there isn't a set way or an easier option i am aware of.
I tried three different options, both of your suggestions an a third one using a block chart. We picked the stacked bar with the text. I added Pop Up text for the sections that are too short for text and it works. Thanks!