Forum Discussion

DaneM123's avatar
DaneM123
Frequent Visitor
8 years ago
Solved

Editing average line label

I have a stacked bar chart, onto which I've added an average line. I'd like to show the label so people know what the line represents, but is there a way to edit the label? The line has been automatically called 'Average Line 1' whereas I'd prefer it to simply say 'Average'. Is this possible using the built-in average line?

Thanks!

Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi DaneM123,

     

    Is it a line from the Analysis pane? If so, you can double click the title to rename the line.

    Editing_average_line_label

     

     

    Best Regards,

    Dale

3 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi DaneM123,

     

    Is it a line from the Analysis pane? If so, you can double click the title to rename the line.

    Editing_average_line_label

     

     

    Best Regards,

    Dale

    • DaneM123's avatar
      DaneM123
      Frequent Visitor
      8 years ago

      Well that was embarrassingly obvious - I'd tried right clicking but not double clicking for some reason. Thank you :)

    • CShaw's avatar
      CShaw
      New Member
      2 years ago

      I noticed that you used Constant Line, instead of Average Line" in order to change the name to "Average."  In an Average Line, the default name is "Average line 1" and you can change it to "Avg" for example, but to make the change show, you'll need to turn "on" the Data lable, and in the "Style" dropdown, select "Name" to just show the name Avg.  To show both name and data label, select "Both."