4.3.6 Displaying Supporting Data in Worksheet Header Rows
Show
In some cases -- for instance, when importing data files in which header information has been pre-defined -- these optional worksheet row headings and the supporting information will display automatically. The information contained in these header rows then becomes available for plotting and analysis operations. Note, however, that once an optional header row has been displayed, you can manually enter information in any header row cell by double-clicking on the cell and editing the cell contents. Data in these fields do not have to derive from file import operations in order to be displayed or to be used in any of the enhanced worksheet and plotting operations that make use of header row (column heading) data. The text and numbers in these header rows -- like text and numbers in data rows -- can be formatted using the Style and Format toolbar buttons. Contents
For information on the worksheet column Long Name, see Origin worksheet column naming conventions. Also, be sure to see Simple Utilities for Filling Columns with Data. Note: The functionality discussed in this page is available to users writing LabTalk script. For more information, see Column Label Row Characters. Displaying supporting information in column label rowsBy default, the Origin worksheet template displays four column label rows -- Long Name, Units, Comments and F(x)= (column formula). These column label rows can be added to or hidden depending on your need to display supporting information in the worksheet. There are two ways to control label row display:
Inserting Notes to Label Row CellsYou can insert a popup note to any label row cell. For instance, adding a popup note to a Comments cell allows you to add extensive comments without having to use vertical space to display comments in full.
UnitsThe Units row stores the units for the worksheet data columns. Origin can make use of this information to annotate graphs. For instance, if the Long Name and Units are specified, they can be used to automatically label the X and Y axes of a 2D graph. Another possible use for the Long Name and Units information is in the graph legend.
CommentsEach worksheet column can have one or more lines of Comments. Multiple comment lines can be typed into the Comments cell by pressing CTRL + ENTER at the end of each line. If you are importing files in which you've pre-defined multiple lines of comments, these are preserved and placed in the Comments cell. F(x)=The F(x)= header row displays either:
Creating the F(x)= expressionExpressions are entered into the F(x)= cell in one of three ways:
F(x)= shortcut menu commandsAssuming direct editing is enabled, you can right-click on the F(x) cell, and enter information into the cell using one of the following:
F(x)= shortcut menu commands for Python function callsWhen the column formula calls a Python function, an additional Open Python File shortcut menu command is shown, if:
CategoriesThe Categories column label row displays when you have designated the worksheet column as containing categorical data (select the column, right-click and choose Set as Categorical ). The cell contents will show (a) whether data are sorted or unsorted (<auto> is selected) or (b) a space-separated list of categories:
For information on creating and customizing graph legends for plots of categorical data, see Legends for Categorical Data. ParametersThe Parameters rows can be used for displaying supporting data such as temperature, pressure, humidity, wavelength, etc. but since these built-in parameters cannot be renamed, most will find the UserDefined parameters to be more useful. For an example of how worksheet Parameter information might be incorporated into an Origin graph, see Customizing Waterfall Plots. To manually add a single parameter to the worksheet:
Sampling IntervalIn an effort to reduce file size, some data files -- particularly those consisting of data collected at regular intervals -- may exclude the independent variable (X column). When this is the case, the Sampling Interval row will display the sampling (X) interval. You can see a quick demonstration of how this works by dragging and dropping a .WAV file into the Origin workspace. SparklinesSparklines can provide a quick view of trends in a set of related datasets contained in the Y columns in a worksheet.
User-Defined ParametersYou can add any number of user-defined parameter rows and assign any name to them. To add a user-defined parameter row to the worksheet header:
or
Note that user-defined parameter rows can also be created on data import, provided your data files contain metadata in the header and you have pre-defined parameters using the Origin Import Wizard.
Formatting User Parameters DataAll worksheet column label row data are stored as strings, even data that appear to be numeric. User Parameter rows do support the formatting of data that have the appearance of being numeric (e.g. a Julian date value such as "2458395"). Other column label rows cannot be so formatted.
Define a Formula when you Add User ParametersYou can add a user-parameter row to the worksheet expressly for the purpose of calculating some column statistic, such as mean or standard deviation.
Shortcut Menu for Column Label RowsThe right-click menu of the column label rows offers controls to edit worksheet headers. Insert User ParametersSelect Insert:User Parameters from the right-click menu to insert a User Parameter above current column label row. Hide/Show Column Label RowsTo hide one or more rows, you can right-click on column label row to select Hide or Clear and Hide from the context menu. If you select Clear and Hide, the information in the current label row will be cleared up and the entire row will be hidden. To show the hidden column label rows, you can do selections from the View shortcut menu or go to the Column Label Rows dialog. See the details in this section. Rename Row LabelThe default displayed column label rows, Long Name, Units, Comments and F(x)= are not able to be renamed, also the Parameter row. Double-click on their row heading(right-click on the heading to select the Edit... context menu), the Move to User Parameter dialog will pop up to let you rename the row label, but convert it into a user parameter. To rename the row label for an existing user parameter:
Edit Customize Label RowsRight click on the column label row and select Edit Column Label Rows... from the context menu, it will open the Column Label Rows dialog. In this dialog, you can hide/show a column label, reorder label rows, add a user-defined parameter, and specify the height for each label row. Move Column Label RowsTo move column label rows:
Set Other Rows as Label RowsTo set one or more rows (column label rows or data rows) as three of the standard column headings (Long Name, Short Name and Units), user-defined parameters, right-click and select Set As Long Name/Units/Comment/User Parameters from the context menu. Append Rows to Label RowsTo append one or more rows to column Long Name or Comment:
Set StylesTo change the text style in the label rows, right click on one column label row, point to the Set Label Name Style menu item, you can set the text in the label rows to rich text, wrap text and/or Float. By clicking the More... item, you can directly go to the format tab of worksheet properties. Copy and Paste Column Label RowsTo copy column label row metadata along with your data selection, right-click and choose Copy (including label rows). Non-contiguous selections and worksheet subrange selections are supported.
When giving a spreadsheet a title what are some best practices to follow select all that?Spreadsheet titles should be short, clear, and state exactly what the data in the spreadsheet isabout. Titles should be shortCorrectSpreadsheet titles should be short, clear, and state exactly what the data in the spreadsheet isabout. 2.
Which data summarization tool do data analysts use to sort reorganize group count total or average data 1 point?Detailed Solution. The correct answer is "Pivot Table". Key PointsPivot Table: We can use pivot tables to sort, reorganize, group, count, total or average data stored in a database.
In which step of the data analysis process would an analyst ask questions such as what data errors?An analyst asks questions such as, “What data errors might get in the way of my analysis?” or “How can I clean my data so the information I have is consistent?” during the process step. This is when data is cleaned in order to eliminate any possible errors, inaccuracies, or inconsistencies.
What is the term for a preset command in a spreadsheet?You can type in a formula (though you have to be sure it's exactly right) or you can use Excel's preset formulas called functions. If you type in the formula, you must start with an equal sign, so Excel knows that the data in the cell is a formula.
|