Hide stacked bar

[o59393]

Hi all

Is is possible to hide a stacked bar and just reflect the data value?

I have 3 stacked bar of percentages and a 4th bar of # number of projects. The last one affects the visual and wont allow me to see the percentages.

I go from percentages bar:

To adding the bar with numbers:

Can I hide the purple one, leave just its numbers and see the percentages bars as in the first image?

Hopefully i am not asking too much 😄

Thanks!!

[v-alq-msft · Accepted solution]

Hi, @o59393 

Based on your description, I created data to reproduce the scenario.

Firstly, You can configure the value of ‘End’ to 3.2 and make sure the color of ‘ID lanuched’ is white.

 

Secondly, you can use ‘ID lanuched’ as value of Customize series in ‘data labels’.

Result:

If I misunderstand your thought, please show me your detailed sample data and expected result. I am glad to solve the problem for you.

Best Regards,

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[o59393]

Yes!

It is working!

Do you know how to order properly the Y axis? Q3 appears before Q2 

Thanks!