Cg_pham at 07:29, 19 January 2012

2012-01-19T07:29:53Z

← Older revision		Revision as of 07:29, 19 January 2012
Line 2:		Line 2:
	{{HelpFiles_Report_Module}}		{{HelpFiles_Report_Module}}

	~~===~~==Change the display information of the legend entries~~===~~==		==Change the display information of the legend entries==

	[[Image:6652.jpg\|321px\|Style sheet - More options - Format]]		[[Image:6652.jpg\|321px\|Style sheet - More options - Format]]

Cg van at 03:55, 14 December 2011

2011-12-14T03:55:12Z

← Older revision		Revision as of 03:55, 14 December 2011
Line 1:		Line 1:
	[[Category:Legend]]		[[Category:Legend]]
			{{HelpFiles_Report_Module}}

	=====Change the display information of the legend entries=====		=====Change the display information of the legend entries=====

Cg_pham at 09:13, 29 March 2011

2011-03-29T09:13:30Z

← Older revision		Revision as of 09:13, 29 March 2011
Line 1:		Line 1:
	[[Category:~~HelpBooks~~]]		[[Category:Legend]]

Catglobe: jrfconvert import

2011-03-07T09:11:55Z

jrfconvert import

New page

[[Category:HelpBooks]]

=====Change the display information of the legend entries=====

[[Image:6652.jpg|321px|Style sheet - More options - Format]]

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:

# 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.
# 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.
# 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:

{| class="tableintopic" style="border-collapse: collapse" width="910" cellpadding="2"
|- align="left" valign="top"
| width="455" |
Use this
| width="455" |
To show this
|- align="left" valign="top"
| width="455" |
<value>
| width="455" |
# 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
|- align="left" valign="top"
| width="455" |
<label>
| width="455" |
The name of the associated data point
|- align="left" valign="top"
| width="455" |
<percent>
| width="455" |
# 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
|- align="left" valign="top"
| width="455" |
<total>
| width="455" |
# 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
__NOTOC__

Change the display information of the legend entries - Revision history

Cg_pham at 07:29, 19 January 2012

Cg van at 03:55, 14 December 2011

Cg_pham at 09:13, 29 March 2011

Catglobe: jrfconvert import