|  | InforShell Trend View

Set up coordinates (X,Y,Z) for creating scatter/bubble plots

Index

Set up coordinates before creating scatter/bubble plots Set up X coordinates for target data |  | Set up Y, Z coordinates for the same target data

Set up coordinates before creating scatter/bubble plots In Trend View spreadsheet for creating diagrams you may either Set up coordinates (i.e. for scatter/bubble plots), or Not set up coordinates (i.e. for line graphs, surfaces and bar charts) For data without coordinates, Trend View will use their row (and/or column numbers) as default coordinates for creating diagrams. |  | When creating scatter/bubble plots you will need to set up coordinate first (i.e. specify which variables to plot on which axis) and then start creating diagrams. Trend View requires you to specify which variables that describe when/where the data is collected (called coordinates), and variables that are the data itself (called target data). This is to facilitate comparing several datasets with universal coordinates, because you can just set up the coordinates once, and roam over the spreadsheet with your mouse to dynamically plot any set of target data. Examples of variables to set as coordinates: data collecting time data collecting temperature
Return to Index

Set up X coordinates for target data 1. Select values to be used as X coordinates Select a set of continuous cells from a row or column as X coordinates Right-click and select "Declare as X coordinate" from the pop-up menu. 2. Select target data related to X coordinates Select a set of cells so that the values of these cells will be used as the values of the corresponding X coordinates in the scatter plot (Note the value cells must locate in the same rows or columns as the coordinate) Right-click and select "Set related value for X coordinate" from the pop-up menu. |  | Figure 1: Select values to be used as X coordinates Figure 2: Select target data related to X coordinates Return to Index

Set up Y, Z coordinates for the same target data Setting up Y, Z coordinates follows same steps as that for X. Note: A valid X, Y or Z coordinate must in the same row or column as its related target value Empty cells are allowed when selecting cells for coordinates or target data. |  | Figure 3: Trend View shows selected X, Y, Z coordinates Return to Index