This may even be necessary if your data files do not contain useful metadata. In some situations, you may opt for direct entry of axis title or legend text. Special characters inserted as Rich Text or Unicode into the worksheet column label rows, are used directly in axis titles or legend text (mm) vs mm, etc.) in axis title and legend text is set on the Preferences: Options: Axis tab. Beginning with Origin 2021, you can click on the legend object and use the Mini Toolbar's Legend Translation Mode button to choose the label row source. The default legend text can be modified by going to the Plot Details > Legends/Titles tab and changing the Translation mode of %(1), %(2) drop-down to use other label row data, including ' Custom'.(see Customizing Display of Units in Axis Title, below).

This notation is linked to the source column name ( Long Name when available, otherwise Short Name) and can be combined with label row Units by going to Plot Details > Legends/Titles tab and checking the box Show Units (when available). The default X axis title for 2D graphs uses a notation of %(?X) the Y axis title uses a notation of %(?Y).Graph axis titles and legends use LabTalk substitution to generate text from project variables.When the default template settings aren't satisfactory you can modify them, with the option of saving your customizations to a graph template. The graph legend entry is formed from the Y column Comments, or 'S32-014-04'.The Y axis title is formed from the Y column Long Name + Units, or 'Delta Temperature(°K)'.The X axis title is formed from the X column Long Name + Units or 'Time(sec)'.

There are several ways to customize text in graph axis titles or legends, but the best solution is generally to make use of worksheet metadata - often, but not limited to, column label row data - as we have done in the following example.īy default, the Line graph template used to make this graph, is configured to use the following label row data: 1.38 FAQ-154 How do I customize the default axis titles and Legend?

Excel graph axis label text