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