Display text values on status chart (Bar, Gauge or Block or ???)

[datagrrl]

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.

[Mark_Little]

Hi,

i would use the text in chart option. You can add an expression

='Yes'&Sum(Value)

You can then use Ctrl+shift to re position

Mark

[datagrrl]

Exactly! Thanks. I didn't think of looking for a box for the Text in Chart when using Ctrl+Shift.

[datagrrl]

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.

[Mark_Little]

Hi,

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.

Mark

[datagrrl]

Okay, thanks so much for your help.

[MarcoWedel · Accepted solution]

Hi,

one solution could be a stacked bar chart like:

hope this helps

regards

Marco

[datagrrl]

Okay, I was trying a stacked bar chart, but I must not have had the settings quite right. That is exactly what I am looking for.

[datagrrl]

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!

[MarcoWedel]

‌you're welcome

regards

Marco