- How to Import Data
- File Formats
- How to Import with Copy & Paste
- How to Set Column Headers
- Paste Special
- Paste Special Example: The decimal separator
- How to Append Data into Existing Columns
How to Select Data
The Basic graphing section shows you how to create basic graphs using a two step process:
- Highlight columns in the data table.
- Click a drawing command shortcut.
This is a shortcut to first adding the drawing command and then selecting the data using the selector menus.
Plot a Subset of Data
When you select columns, the drawing command will plot all of the rows in those columns. However, in some cases you might want to only use a subset of the data.
To plot a subset of data apply a Mask.
- Click the top left corner to expand a command.
- Find the Use as mask section.
- Use the menu selector to pick a column to use as a filter.
Plot Command Example
Masks are logical statements that can be based on text columns or number columns. You can include multiple lines to your mask.
Here is a simple example.
NOTE: Use the small + button to the right to add additional criteria. There is not limit to the number of criteria.
Mask Menu Selector
You can select any column in the data table. You can mask based on a column that is different from the x or y coordinate. Once you select the column, new entries will show up on the right of this menu.
You can apply a mask to individual commands or to a group of commands using a Command Group.