Forum Discussion
Post ProdigyHide stacked bar
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!!
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.
2 Replies
v-alq-msftCommunity Support
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!
