Forum Discussion
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
- jie_ni_tanNew Member
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_SalRegular Visitor
I have the same question.
- Golfer_SalRegular 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-msftMicrosoft 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-msftMicrosoft 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