Forum Discussion

jie_ni_tan's avatar
jie_ni_tan
New Member
8 years ago

Different data label format for combo chart

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!

5 Replies

  • 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!

     

     

  • Golfer_Sal's avatar
    Golfer_Sal
    Regular Visitor

    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's avatar
      v-yulgu-msft
      Microsoft Employee

      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

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee

    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