220.127.116.11 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
|Label tab for 2D Vector
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.
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.
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.
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.
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).
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.
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.
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).
Select this check box to put a white background behind each label.
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.
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.
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.
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.
Specify the label position. This option is not available for Box Chart.
|| 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.
| Inside End
|| This option applies to Column/Bar graphs.
Place label inside the column/bar and close to the line where column/bar ends.
| Inside Base
|| This option applies to Column/Bar graphs.
Place label inside the column/bar and close to the line where column/bar starts.
| Outside End
|| This option applies to unstacked Column/Bar graphs.
Place label outside of the column/bar and close to the line where column/bar ends.
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
Specify the quantities or data set to be used for creating the label.
|| Use X values of the data as labels.
|| Use Y values of the data as labels.
| Row Indices
|| Use row indices as labels.
| (X, Y)
|| 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.
Advanced Position Controls
These controls are only available when the plot type is line/symbol in the 2D Cartesian coordinate system.
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.
|| Use the position of the corresponding data points as reference.
| X Line
|| Use a line of X = Value as reference, i.e. a line parallel to the Y axis.
| Y Line
|| Use a line of Y = Value as reference, i.e. a line parallel to the X axis.
| Error Bar
|| 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.
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.
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.
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)).
Select the line style of the leader line.
Determine the width of the leader line.
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.