# 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

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 space-separated row indices. 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. ## 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. ## 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. ## Label Style ### 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.(Tools: Option). ### 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. ### 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 Color control will be disabled. • When Box is selected, a box will be added as a frame around the label text. You can change the border color using the Border Color control and the fill color using the Fill Color control . • When Shadow is selected, a box and its shadow will be added around the label text. You can change the border color and shadow color using the Border Color control and the fill color of the box using the Fill Color control . 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. ### 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. ### 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 (Tools: Options). ### White Out Select this check box to put a white background behind each label. ### The formatting buttons Click the text formatting buttons (Bold, Italic, and Underline) to format the label text. ## 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. ## Horizontal Offset and Vertical Offset The Horizontal Offset box setting determines the horizontal offset of the data labels. The Vertical Offset box setting determines the vertical offset of the data labels. The offset is measured as a percentage of the font height. ## 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. ## Justify This control is only available for Box Chart. ## 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 ## 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. Click the arrow to the right-side of the control to see some example formatting options. Select from the list or type into the box using this list of 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. Clicking the Format String drop-down will display some example formatting options. • 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.

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.

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