Forum Discussion
Data label Display Unit
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.
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 Zhi
If 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.
I have checked afew times, but I do not have Y-Axis(line) ....
Any idea why?
Hi Yuiitsu ,
Did you use "Line and clustered column chart"? If so, when you add field in column and line, you could click Y-axis
Then when Y axis expand, you could slip Scroll Bar, then you will see it(because it have two y-axis, you could set them separately)
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.