|
Dialog Reference | PopChart Builder User Guide 4.0.5 |
This dialog controls the appearance of data labels. Data labels are boxes of text that usually appear above a data item. The dialog can be selected by double-clicking on any data label, or by selecting graph and then selecting Properties > Data Label Properties.
This dialog pane allows you to specify general properties for your data labels.
Specifies when the graph will display data labels. The available options are:
The graph will never display data labels.
The graph will always display data labels.
The graph will display data labels only when a user "rolls over" the corresponding bar, line, or wedge with their mouse pointer.
Note: When you use roll-over data labels, the letters RO will appear in the data label boxes while you are in the PopChart Builder interface. This is to indicate that the boxes will only appear as the user rolls his or her mouse over the data item.
Sets the location of the graph's data labels. Depending on the graph type, different options will be available. The image to the right of this setting indicates the effect of the various options. These options include the following:
The data label will appear above the line or data item.
The data label will appear below the line or data item.
The data label will appear above the bar (or to the right for a horizontal bar).
The data label will appear just below the top of the bar (or just to the left of the right end of a horizontal bar).
The data label will appear at the bottom of the bar (or at the left end of a horizontal bar).
The data label will appear just below the top of the bar (or just to the left of the right end of a horizontal bar).
The data label will appear at the bottom of the bar (or at the left end of a horizontal bar).
The data label will appear just below the top of the bar (or just to the left of the right end of a horizontal bar).
The data label will appear at the bottom of the bar (or at the left end of a horizontal bar).
This controls how the text in your data labels will appear. Your data format string can include regular text, such as a currency symbol or percent character, or it can include any of the data-specific macros listed in the Value Keywords pull-down menu.
For information about the data label format string and macros, refer to "Custom Data Label Formatting" in Chapter 1.
This is a list of macros that can be used in the data label format string. You can insert any of these macros into the data label format string by selecting the appropriate macro and clicking on the Insert button. A complete list of these macros is available in Table 1.1 on page 1-13.
Specifies whether or not the data label should have a border. You can control the color of this border by clicking on the Color button next to it, which will launch a Color Properties dialog (refer to "Color Properties").
The maximum width of the data label. If the data label exceeds this width, it will be wrapped.
In an area or stacked bar, you can either show a data label for each data segment, or you can show a data label for the entire stacked bar or area. Check this box if you want to show just one data label for the entire stacked bar or area.
This setting affects how the data value is shown. The options available will depend on the graph type:
The default setting, this means that the value will appear just as it was entered into the graph's spreadsheet.
The graph will show each data value as a percentage of the sum of all data values in the entire graph.
This setting allows you to add the series label to the data label for each wedge in a pie graph. The image above this setting, which changes as you make changes, shows you how the graph will appear with the currently selected setting. Available options include:
This is the default setting. Only the data value will be in the data label.
Only the series label will be in the data label.
The data value and the series label will both be in the data label.
The series label will appear outside of the pie, while the value will appear inside of it.
(Roll-over labels only) The series label will appear above the pie, while the value will appear as specified in the Position setting.
(Roll-over labels only) The series label will appear below the pie, while the value will appear as specified in the Position setting.
(Roll-over labels only) Both the series label and data value will appear above the pie.
(Roll-over labels only) Both the series label and data value will appear below the pie.
These settings affect the numerical format of the graph's data labels.
This allows you to specify how a data label will be displayed in a pie graph. The options are: General, Currency, and Percentage.
If the data value is negative, the graph will use this setting to determine how to display it. It can be displayed either as a minus sign -, in parenthesis ( ), or as an absolute value (no negative value indicator).
If this is checked, the number will always be shown as a decimal, regardless of whether it was entered into the spreadsheet as such. It will be shown to as many places as indicated in the Decimal Places property.
The number of decimal places to show. Data values that have more decimal places will be rounded to the nearest decimal at this point.
Specifies whether or not to show a thousands separator. For example, if a comma is used as the thousands separator (see "Thousands"), one million will be shown as 1,000,000 when this box is checked. Otherwise, one million would be shown as 1000000.
Specifies font characteristics for data labels. For more information, refer to "Font Properties".
This dialog pane controls the format of the data value in the data label.
This setting affects the numerical format of the value returned by any macros that return values (e.g. %_VALUE).
If the data value is negative, the graph will use this setting to determine how to display it. It can be displayed either as a minus sign -, in parenthesis ( ), or as an absolute value (no negative value indicator).
If this is checked, the number will always be shown as a decimal, regardless of whether it was entered into the spreadsheet as such. It will be shown to as many places as indicated in the Decimal Places property.
The number of decimal places to show. Data values that have more decimal places will be rounded to the nearest decimal at this point.
Specifies whether or not to show a thousands separator. For example, if a comma is used as the thousands separator (see "Thousands"), one million will be shown as 1,000,000 when this box is checked. Otherwise, one million would be shown as 1000000.
These setting affects the numerical format of the value returned by the %_PERCENT_OF_CATEGORY and %_PERCENT_OF_TOTAL data label macros.
If this is checked, the percentage will always be shown to number of decimal places indicated in the Decimal Places property.
The number of decimal places to show. Percentages that have more decimal places will be rounded to the nearest decimal at this point.
|
|