different unit in column values and line values

[david1114bi]

Dear all,

I have two values about sales total  and hit rate, I put them in the line and column chart.

I want to lock the sales total unit in "millions" and the hit rate in %, so I set the unit in million in the data labels, and It control two of the units in the same time, the % change to % in million and it shown 0.0%M

how can I only lock the unit of sales total with no change in hit rate?

Thanks

[v-yulgu-msft]

Hi @david1114bi,

Unfortunately, it is not supported to apply the unit settings to only one value. You may submit an idea here.

Regards,

Yuliana Gu

[david1114bi]

Dear All,

I want to show sales total and hit rate in the line and column chart.

I want to lock the unit of sales total in million and keep unit of hit rate in %.

So I set the unit in data labels, the sales total unit change to million, while the hit rate unit change to 0.00%M

how can I only change the unit of sales total and keep the hit rate in %?

Thanks

[david1114bi]

Dear all,

I want to show sales total and hit rate values in the line and column chart.

I want to lock the unit of sales total in "million" and keep the unit of hit rate in "%", so I set it on the data labels but it contral the unit in both. the hit rate % change to 0.00%M

how can I lock the unit in sales total with no change in hit rate?

Thanks