See related video:Labeling Data Plots Based on Data in any Worksheet Column
You can specify label source in two ways:
Note that pre-designating a worksheet Label column and using it to label a plot no longer creates a label dataset in Plot Details, as it did in earlier versions of Origin. All data labels now use the Label tab controls of the Y dataset, as documented below.
_Label2_Tab/Labelling_Data_Points1.png?v=85627)
Select this check box to enable adding labels to data plots.
Note that prior to Origin 2020b, checking this box enabled labels for all plots in a plot group. To accommodate improvements to showing data at specified points only, this box now only enables labels for the selected plot, whether or not it is part of a group. However, you can still use the Show Data Labels button on the Mini Toolbar to label all plots.
To add data labels to ALL plots in your group, simultaneously:
|
Check this box to label specified data points only. Once enabled, use the list box to locate labels by:
| Syntax | Description | Example |
|---|---|---|
| a b c d e | Show labels at space-separated list of row indices | 1 4 5 9 |
| n:m:s | Show labels from rows n to m, skipping every s rows | 2:0:5 |
| x=a b d g | Show labels at x values | x=3.5 7.8 10.2 14.0 |
| [BookN]sheetM!col(A) | Show labels at row indices contained in specified column | [Book1]Sheet2!Col(A) |
| x=[BookN]sheetM!col(A) | Show labels at x values listed in specified column | x=[Book1]Sheet2!Col(A) |
One use of this feature might be to use plot metadata to label individual plots instead of using a standard graph legend. For more information, see FAQ-1065 How to label each line plot with a legend-type entry? |
Enable the percentile labels for the box chart.
| Box Range | Show the labels of the top, the median and the bottom lines mext to the box plot.
For example, when you select Perc 25, 75 from the Range list for Box, the labels for the 75th percentile, median and 25th percentile, will display in the graph. |
|---|---|
| Whisker | Show the label of upper and lower whisker next to the box plot. |
| Mean | Show the label of mean next to the box plot.
The location of the mean can be marked by symbols (Percentile tab) and/or horizontal lines (Lines tab). You must enable mean display on at least one of these tabs before you can choose to label the mean. Beginning with Origin 2020, you can mark the location of the mean using a horizontal line, without showing a box (e.g. on the Box tab, set Type = Data) but you will have to enable Type = Box momentarily, in order to check the Labels boxes. Once checked, you can disable box display and your horizontal line will remain labeled. |
| Median | Show the label of median next to the box plot.
The location of the median can be marked by symbols (Percentile tab) and/or horizontal lines (Lines tab). You must enable median display on at least one of these tabs before you can choose to label the median. Beginning with Origin 2020, you can mark the location of the median using a horizontal line, without showing a box (e.g. on the Box tab, set Type = Data) but you will have to enable Type = Box momentarily, in order to check the Labels boxes. Once checked, you can disable box display and your horizontal line will remain labeled. |
| Outliers | Specify whether to show the labels of outliers. Once this check box is checked, you can use the Leader Line for Outliers group to add leader lines for the outliers with specified offset been exceeded. |
| Show | Specify to show the Value, Percentile or both for the Box/Whisker/Mean Value Labels. |
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).
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 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.
Select this check box to put a white background behind each label.
Type or select the angle, in degrees, by which to rotate the label.
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. Emphasis means the Bold, Italic and Underline label formats of this special point follows the plot. Uncheck it to edit the formatting buttons below.
Click the text formatting buttons (Bold, Italic, and Underline) to format the label text.
Used to align multi-line data labels. Not available for all plot types.
Auto: Follow the Position setting:
Other combinations are possible by setting Alignment = Left, Right or Center.
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.
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.
When Box or Shadow is select as Frame, you can set a border color for box of the labels.
When Box or Shadow is select as Frame, you can set a fill color for box of the labels.
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.
Specify the quantities or data set to be used for creating the label.
| X | Use X values of the data as labels. |
|---|---|
| Y | 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. |
| Custom | Use content and format specified in Format String to create the labels (see next section). |
| Col(ColumnShortName) | 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 Notes:
Format String Notes:
_Label2_Tab/Label_Form_Custom_2.png?v=75777)
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.
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.
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 is measured as a percentage of the font height. Enter a positive or negative value to adjust label position.
Specify the label position. This option is not available for Box Chart.
| Center | Place label in the center of the data point. |
|---|---|
| Left | Place label to the left or right of the data point. |
| Right | |
| Above | Place label above or below the data point. |
| Below | |
| 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, bridge chart or lollipop plot.
For Column/Bar graphs and bridge chart, selecting Outside End will place label outside of the column/bar and close to the line where column/bar ends. For the plots with drop lines, such as lollipop plot which has the drop lines connecting two data plots, selecting Outside End will place the labels away from the end points of the drop lines for the plot(s). |
| Auto | 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. |
| Angular Outer | This option is available for circular Dendrogram.
Place labels to the outside of leaves. |
| Angular Inner | This option is available for circular Dendrogram.
Place labels alongside of leaves. |
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
This control is only available for Circular Packing graphs.
Use it to automatically hide labels for categories whose fraction accounts for less than N%.
This control is only available for Circular Packing graphs.
Use it to automatically wrap labels to a percentage of category diameter.
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.
| Data | 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.
|
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.
They are used for repositioning overlapping data labels.
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).
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)).
|
|
Image(1) |
Image(2) |
To obtain an "L-shaped" leader line as in the following image, set Connect = Step-Horz and enter 0 in the accompanying text box. |
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.
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.
This control is only available for Dendrogram graphs.
Check this check box to hide the overlapped labels automatically.
This drop-down option is only available for the Heatmap graph, including Heatmap with Split Tiles.
It supports Square, Upper Triangular, Upper Triangular without diagonal, Lower Triangular Lower Triangular without diagonal and By Value four display styles for the labels.
When you select By Value, for the label values set by Label Form, you can set a value condition to decide which cells should show the labels.
| Note:
If the Heatmap X and Y is not N*N, these four options, Upper Triangular, Upper Triangular without diagonal, Lower Triangular and Lower Triangular without diagonal are not avaiable. |
Add additional labels for a box chart.
_Label2_Tab/The__28Plot_Details_29_Label2_Tab_AdditionalLabels.png?v=0)
This control group can be used to add significance marks on the heatmap cells.
Specofy whare to show the siginificant marks.
This editable combo list can specify the data source to decide siginificant marks.
Enter the significant levels to divide the data source. These ranges will be used to decide the marks which will be shown for the values.
Enter the symbols as significance marks. By default Auto is selected, which provides number of * acorrding to number of value in Significant Level.
Click it to add a footnote below the graph to show the significant levels.
For example, if Level is set 0,05 0.01 0.001, and Symbol is set to Auto(* ** ***)
And the footnote for significant levels will show:
* ≤ 0.05 ** ≤ 0.01 *** ≤ 0.001