Change the display information of the legend entries



Change the display information of the legend entries

To change the display information of the legend entries in a bar line, pie, area, point, radar, funnel, bubble, or box and whiskers chart through the External Style Sheet and Inline Style Sheet editors:

1. Under Labels, select Legend, click the More options button in the bottom right-hand corner of the right-hand area, and then find the Format group of settings in the dialog that turns up.
2. Specify the display information of the legend entries by selecting an option from the Format combo box. Each option is a tag or a combination of tags and text. A tag tells the legend entries which information to display.
3. Instead of selecting an option, you can enter your own text combined with specific tags in the combo box to form exactly what you want the legend entries to display.

Note: You can change the display information of the legend entries when they represent individual data points. However, you cannot when they represent data series as it is always the names of the data series that they display.

The following table shows you what a legend entry displays for a specific tag when it represents an individual data point:

Use this	To show this
<value>	The value of the associated bar in a bar line chart The start value of the associated float bar in a bar line chart The value of the associated marker in a line or step line series in a bar line chart The value of the associated marker in a series in an area or radar chart The value of the associated segment in a pie or funnel chart The Y value of the associated point in a point or bubble chart The upper box value of the associated box in a box and whiskers chart
<label>	The name of the associated data point
<percent>	The value of the associated bar as a percentage of the total of the values of all the bars in the same bar series in a bar line chart that is displayed in the Clustered mode The value of the associated bar as a percentage of the total of the values of all the bars and the start value of the float bar if any in the same stack in a bar line chart that is displayed in the Stacked mode The value of the associated bar as a percentage of the total of the values of all the bars in the same stack (excluding the start value of the float bar if any) in a bar line chart that is displayed in the Stacked percent mode The start value of the associated float bar as a percentage of the total of the start values all the float bars in the float bar series in a bar line chart that is displayed in the Clustered, Stacked, or Stacked percent mode The value of the associated marker as a percentage of the total of the values of all the markers in the same line or step line series in a bar line chart The value of the associated marker as a percentage of the total of the values of all the markers in the same series in an area or radar chart The value of the associated segment as a percentage of the total of the values of all the segments in a pie or funnel chart The Y value of the associated point as a percentage of the total of the Y values of all the points in the same series in a point or bubble chart The upper box value of the associated box as a percentage of the total of the upper box values of all the boxes in the same series in a box and whiskers chart
<total>	The total of the values of all the bars in the same bar series in a bar line chart that is displayed in the Clustered mode The total of the values of all the bars and the start value of the float bar if any in the same stack in a bar line chart that is displayed in the Stacked mode The total of the values of all the bars in the same stack (excluding the start value of the float bar if any) in a bar line chart that is displayed in the Stacked percent mode The total of the start values all the float bars in the float bar series in a bar line chart that is displayed in the Clustered, Stacked, or Stacked percent mode The total of the values of all the markers in the same line or step line series in a bar line chart The total of the values of all the markers in the same series in an area or radar chart The total of the values of all the segments in a pie or funnel chart The total of the Y values of all the points in the same series in a point or bubble chart The total of the upper box values of all the boxes in the same series in a box and whiskers chart