how can I have the number always shown on the bar or near the line?

I want the chart shows the number value on the bar / line for us to see the figure.

currently I can only get the number when I move the mouse arrow to that position.

how can I have the number always shown on the bar or near the line?

Thanks,

Tagged:

Best Answer

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Lu_zhang In the "Text" box in the data label settings, change "VALUE" to "%_VALUE" for the macro to show the field value instead of the word "VALUE". You can also click the plus (+) sign in the text box to auto-fill the macros.

    If you want to always show the labels on the bars and lines, change the "Show datalabels on" drop-down from "Default" to "Lines and Bars".

Answers

  • MichelleH
    MichelleH Coach
    Answer ✓

    @Lu_zhang In the "Text" box in the data label settings, change "VALUE" to "%_VALUE" for the macro to show the field value instead of the word "VALUE". You can also click the plus (+) sign in the text box to auto-fill the macros.

    If you want to always show the labels on the bars and lines, change the "Show datalabels on" drop-down from "Default" to "Lines and Bars".