Forum Discussion
Data label Display Unit
Dear Experts
Once again I seek help of experts here with regard to the display unit for data labels.
I want the line to show in % but the column in Millions. Is that possible?
When I change my display unit to millions it will change my line as well.
Please take a look at my SS.
Hi Yuiitsu ,
You could set unit in line and clustered column chart like below(you need to make sure you set this in Y-axis(column))
In addition , you said that "When I change my display unit to millions it will change my line as well", which part change? Please inform me in details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
11 Replies
I was actually checking into this earlier today on a different thread. I cannot find any way that you can independently control the data labels between columns and line.
Thank you for confirming!
Hi Yuiitsu ,
You could set unit in line and clustered column chart like below(you need to make sure you set this in Y-axis(column))
In addition , you said that "When I change my display unit to millions it will change my line as well", which part change? Please inform me in details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you!
I did not thought of changing the display unit in Y-axis.
I changed in "Data Label" and this is what happened:
Hi Yuiitsu ,
Yes, when you change unit in "Data Label", it will aplly to both line and column, this is by design. So I suggest you could change this in Y-axis, which should work.
In addition, you could change line unit in Y-axis(you will see in it Y-axis(line))
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
