different unit in column values and line values

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

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

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