Different data label format for combo chart

[jie_ni_tan]

Hi,

In my combo chart, I would like to show the data label of my line to be in percentage, and the data label of my columns to be in thousands.

When i set the display format to be [auto], I get the percentage for my line, but the columns are in millions.

When i set the display format to be [thousands], i get the correct label for my columns, but the data label for my line shows 0K%.

What can I do? Thanks!

[v-yulgu-msft]

Hi @jie_ni_tan,

Based on my test, it is not possible to set different format for data labels in combo chart right now. You could submit this idea here.

Regards,

Yuliana Gu

[Golfer_Sal]

For your Y-Axis, please set Position: "Left" to be "Auto" for the Display units and the display units of Poisition: "Right," which is the scale of your line chart, set o be "None."  It shows the line chart as % without K. 

[v-yulgu-msft]

Hi @Golfer_Sal,

In my test, there is no "Auto"option for the position of  Y-axis. If you have achieved the requirement that set different data label formats, could you please share more detailed steps?

Regards,

Yuliana Gu

[Golfer_Sal]

I have the same question.

[jie_ni_tan]

Hi,

In my combo chart, I would like to have percentage data label for my line, and the data label of my columns to be in Thousands.

When I set the data label display to be [auto], I get my percentage data label, but the data label of my columns is in millions.

When I set the data label display to be [thousands], the data label of my columns is correct, but the data label of the line shows 0K%.

What can I do? Thanks!