9.3.7.7 The (Plot Details) Label Tab (Without Label Column)

This tab allows you to add labels to your 2D data plot using X, Y values, metadata, or information from other column(s) in the worksheet. The data labels should be added using this method. It is not necessary to set the column Plot Designation to Label. There is support for custom formats; you can label plots using worksheet data (including data in other columns) and control the label format.

 Label tab for 2D line and/or symbol plot or 2D Column/Bar plot in Cartesian coordinate system Label tab for Box Chart(Only available when the Box Labels check box is selected in the Box tab) or Histogram graph. In the Box plot, this tab controls the setting for the label of Box Range, Whisker, Mean or Median. Label tab for 2D Vector Label tab for Dendrogram

Note: If your graph includes data from a column whose Plot Designation was set to Label (older method), another Label tab will be included in the Plot Details dialog box.

Enable

Select this check box to enable adding labels to data plots.

Show at Specified Indices Only

Check this check box show labels only at data points of specified row indices. For the specified indices, you can set by entering space separated values or choosing a dataset from the dropdown list.

One use of this feature might be to use plot metadata to label the plot instead of relying on the graph legend to identify plots. E.g. If you check this checkbox and enter 0 as the index, then set Label Form as Custom and Format String as %(wcol(n)[L]$), the Long Name of each plot would be displayed at the end ("0" = last index) of the plot. Indices from dataset or space separated numbers (0=Last) This text box is only available when the Show at Specified Indices Only check box is selected. Enter space-separated row indices to specify the data points at which labels will be shown. By default, points are labelled with Y column values, at specified indices. Use the Label Form list to use X or both X and Y (X,Y). When entering space-separated values, the integer 0 corresponds to the last data point of the active plot. Alternately, use range notation [BookName]SheetName!ColumnName to specify a column of row indices (e.g. [Book1]Sheet1!Col(A)). If the index dataset is from same workbook, [BookName] is not needed; Likewise, if the index dataset is from the same worksheet, [BookName]SheetName! is not needed. Font Font Select the desired font for label text. Select Default: FontName to use the font determined by the Default drop-down list on the Text Fonts tab of the Options dialog box.(Preferences: Option). Size Type or select the desired font size (in points) for the label text. The default size is determined by the Size combination box value in the Text Tool group on the Text Fonts tab of the Options dialog box (Preferences: Options). Color Select a color for the labels. If color is set to Auto and the Auto Color of Label Follows Symbol box is selected on the Miscellaneous tab (page level) of Plot Details, then label color follows symbol color. If color is set to Auto and the Auto Color of Label Follows Symbol box is cleared on the Miscellaneous tab (page level) of Plot Details, then label color will be chosen to display in highest contrast to the background color. White Out Select this check box to put a white background behind each label. Rotate (deg) Type or select the angle, in degrees, by which to rotate the label. • Positive values rotate the label counter-clockwise. • Negative values rotate it clockwise. Zero degrees is horizontal text. Emphasis This checkbox is only available for special points. When a data point becomes special, its properties will follow that of the plot until you customize it. Emphasis means the Bold, Italic and Underline label formats of this special point follows the plot. Uncheck it to edit the formatting buttons below. The formatting buttons Click the text formatting buttons (Bold, Italic, and Underline) to format the label text. Frame Frame Specify whether add a frame around the label text. This option is not available for Box Chart. Three selections are available for this drop-down list: None, Box and Shadow. • None is select by default; meanwhile, Border and Fill color control will be disabled. • When Box is selected, a box will be added as a frame around the label text. • When Shadow is selected, a box and its shadow will be added around the label text. Please note that the Frame option will be set to Auto for the special point by default. It means that the settings of special point will follow that of the whole plot. Of cause, you can customize these settings for the special point for your own needs. Border When Box or Shadow is select as Frame, you can set a border color for box of the labels. Fill When Box or Shadow is select as Frame, you can set a fill color for box of the labels. Margin(% Font Height) Adjust the margin of the frame in the percent of font height. The top/bottom/left/right margin shares the same value. This option is not available for Box Chart. Please note that this option will be set to Auto for the special point by default. It means the settings of special point will follow that of the whole plot. Of cause, you can customize these settings for the special point for your own needs. Label Source Label Form Specify the quantities or data set to be used for creating the label.  X Use X values of the data as labels. Use Y values of the data as labels. Use row indices as labels. Use both X and Y values of the data as labels. Use content and format specified in Format String to create the labels. Use the desired column from the worksheet as labels. All columns located to the right of the data Y column will be listed here. Numeric Display Format/Format String • When Label Form is set to X, Y or (X/Y) or Col(ColumnShortName), a Numeric Display Format box becomes available. See Origin Formats. Supported formats include D (date) and T (time) options as long as the date and time data display in the worksheet as numeric Julian Date values. • When Label Form = Custom, a Format String box becomes available. See Syntax and notations used in plot label. Note that clicking on the Numeric Display Format or Format String lists shows prototyped formats. Format String Notes: • In this box, column designators col() and wcol() and arbitrary fixed strings can be combined, as desired. • The %() substitution and$() substitution can be used here (for example, $(wcol(n)[i], *4) translates to "show the Y values of the current plot and set decimal places to 4" or %(wcol(n)[L]$) translates to "show the Long Name of current Y column as labels", with L indicating the Long Name of current column -- see Column Label Characters for a full list of the column label rows' substitute characters).
• Columns to the left or right of the current Y column can be referred to by column index (e.g. col(2)[i] or wcol(n+1)[i]), or by Short or Long Name (e.g. col(B)[i] or col(Percent)[i]).
• Numeric and date/time formats are modified using these specifiers.
• Before Origin 9.0, you could only use $(x) to get numeric values. Origin 9.0 and later support x$/y$/z$ which is useful for categorical data. For example, %(X$) is used to return categorical data in the x column, whereas$(x) only shows the index value of the categorical data.

Show

This drop-down list is only available for Histogram graph.
You can use this option to specify which values to show as labels, Count, Percentage(relative frequency for each bin in percent format) or Both.

Attach to

This group is only available for Vector graph.
Choose to place labels to Arrow Head or Arrow Tail. If the vector graph is created from XYXY dataset, the coordinates the label shows will be that of the end point the label attaches to.

Auto Offset

This checkbox is only available for special points.
When a data point becomes special, its properties will follow that of the plot until you customize it. Auto Offset means the label position of this special point follows the plot. Uncheck it to customize Horizontal Offset and Vertical Offset.

Label Offset

Label offset is measured as a percentage of the font height. Enter a positive or negative value to adjust label position.

• Horizontal Offset
• Vertical Offset
• Angular Offset (Circular Dendrogram)

Position

Specify the label position. This option is not available for Box Chart.

 Center Place label in the center of the data point. Place label to the left or right of the data point. Place label above or below the data point. This option applies to Column/Bar graphs. Place label inside the column/bar and close to the line where column/bar ends. This option applies to Column/Bar graphs. Place label inside the column/bar and close to the line where column/bar starts. This option applies to unstacked Column/Bar graphs. Place label outside of the column/bar and close to the line where column/bar ends. This option is available for vertical/horizontal Dendrogram. Always place labels to the opposite side of leaves. It is useful to auto reposition labels after exchanging XY axes. This option is available for circular Dendrogram. Place labels to the outside of leaves. This option is available for circular Dendrogram. Place labels alongside of leaves.

Hide Label if Column/Bar Height Less than (%)

This control is only available for 2D Column/Bar graphs.
Use it to hide the column/bar label if the height/length of column/bar is less than the specified value. Only whole numbers are supported.

Critical Length = percentage value% * Y axis length

These controls are only available when the plot type is line/symbol in the 2D Cartesian coordinate system.

Attach to

Specify the reference position of the data label. The data label position will be calculated based on the Horizontal Offset, Vertical Offset and Position settings from the reference position.

 Data Use the position of the corresponding data points as reference. Use a line of X = Value as reference, i.e. a line parallel to the Y axis. Use a line of Y = Value as reference, i.e. a line parallel to the X axis. Use the position of error bar as reference. For the Y error bar, it will take effect when position is Above or Below. For the X error bar, it will take effect when position is Left or Right.

X/Y Value

This text box is only available when Attach to is set as either X Line or Y Line.

It is used to specify the Value that determines the reference position. The value can be an arbitrary double, or can be LabTalk notations such as X1 X2 Y1 Y2. X1/X2 refers to the From/To values of the X axis, and this is similar for Y1 and Y2.

Auto Reposition of Data Labels

They are used for repositioning overlapping data labels.

Auto Reposition to Avoid Overlapping

This check box is used to specify whether to turn on reposition to avoid overlapping. If it is not selected, the positions of data label remain relative to data even though they are overlapping with other data labels, data points, or leader lines.

Reposition Direction

This drop-down menu is only available when Auto Reposition to Avoid Overlapping is checked.
It is used to specify the direction to move data labels when re-position needs to be applied. Choose between X and Y to re-position the data labels either along X axis or along Y axis.

The leader line is a line object connecting the data label and its reference position (determined by the Attach to drop-down list).

Show Leader Line if Offset Exceeds (%)

This check box controls display of the leader line. Leader lines will only be shown if the offset between data labels and data points exceeds a certain critical length. The critical length is defined using the Percent Value in the text box next to the check box.

Critical Length = Percent Value% * (Layer Height + Layer Width)/2.

Connect

Select the leader line connection type. The seven options are Straight, Polyline-Horz, Polyline-Vert, Step-Horz, Step-Vert, Horizontal and Vertical . Polyline-Horz and Polyline-Vert create three segment lines where the middle segment is angled. Step-Horz and Step-Vert create three segment lines where the middle segment is perpendicular.

If Polyline-Horz or Polyline-Vert is chosen, you can change the percent of horizontal or vertical distance between two inflection points in the text box after the Connect drop-down list(see the below image(1)). Similarly, if Step-Horz or Step-Vert is chosen, you can specify the position of the inflection point by the percent of horizontal or vertical distance in the text box after the Connect drop-down list(see the below image(2)).

 Image(1) Image(2)

Style

Select the line style of the leader line.

Width

Determine the width of the leader line.

Color

Determine the color of leader line either by system color or custom color. If it is set as Auto, the color setting of leader line will follow the color of data labels.

Show Label for Leaves Only

This control is only available for Dendrogram graphs.

Check this check box to show label of the leaves only. It means the label of nodes will be hidden.

Auto Hide Overlapped Labels

This control is only available for Dendrogram graphs.

Check this check box to hide the overlapped labels automatically.