InforShell
Trend View

Create 2D, 3D scatter plots and bubble charts
in Trend View spreadsheet



Index

  • Create 2D scatter plots
  • Create 2D bubble charts (plot 3D data in 2D diagram window)
  • Create 3D scatter plots
  • Create 3D bubble charts (plot 4D data in 3D diagram window)
  • Add Trendline for 2D/3D scatter plots and bubble charts
  • Interactively drive 2D and 3D diagram window

  • Create 2D scatter plots

    Steps:
    1.
    Set up X coordinates
    2. Select cells you want to include in the plot from those you set up as target data
    3. Right-click and select "View 2D plot" from the pop-up menu
    4. In 2D diagram window right-click and select "View X,Y (Scatter)"


    Figure 1: Select 2D diagram window with 2D data


    Figure 2: Create 2D scatter plots

    In a 2D scatter plot, all data values from the selected cells are displayed using same sized balls, i.e.

  • Each ball's horizontal position is decided by its X coordinate
  • Its vertical position (Y) is decided by the cell value
  • Return to Index


    Create 2D bubble charts (plot 3D data in 2D diagram window)

    Steps:
    1.
    Set up X, Y coordinates
    2. Select cells you want to include in the plot from those you set up as target data
    3. Right-click and select "View 2D plot" from the pop-up menu
    4. In 2D diagram window right-click and select "View X,Y,Z (Bubble)"


    Figure 3: Select 2D diagram window with 3D data


    Figure 4: Create 2D bubble charts

    In a 2D bubble chart, all data values from the selected cells are displayed using individually sized balls, i.e.

  • Each ball's position is decided by its X, Y coordinate
  • The size of the ball is decided by the cell value
  • Return to Index


    Create 3D scatter plots

    Steps:
    1.
    Set up X, Y coordinates
    2. Select cells you want to include in the plot from those you set up as target data
    3. Right-click and select "View 3D plot" from the pop-up menu
    4. In 3D diagram window right-click and select "X,Y,Z Scatter"


    Figure 5: Select 3D diagram window with 3D data


    Figure 6: Create 3D scatter plots

    In a 3D scatter plot, all data values from the selected cells are displayed using same sized balls, i.e.

  • Each ball's horizontal position is decided by its X, Y coordinate
  • Its vertical position (Z) is decided by the cell value
  • Return to Index


    Create 3D bubble charts (plot 4D data in 3D diagram window)

    Steps:
    1.
    Set up X, Y, Z coordinates
    2. Select cells you want to include in the plot from those you set up as target data
    3. Right-click and select "View 3D plot" from the pop-up menu
    4. In 3D diagram window right-click and select "X,Y,Z,V Bubble"


    Figure 7: Select 3D diagram window with 4D data


    Figure 8: Create 3D bubble charts

    In a 3D bubble chart, all data values from the selected cells are displayed using individually sized balls, i.e.

  • Each ball's position is decided by its X, Y, Z coordinate
  • The size of the ball is decided by the cell value
  • Return to Index


    Add Trendline for 2D/3D scatter plots and bubble charts

    In 2D/3D diagram window right-click and select "Show Trendline" or "Hide Trendline"


    Figure 9: Trendline equation
    Return to Index


    Interactively drive 2D and 3D diagram window

    Automatically graph current data range:

  • Create an initial plot with a subset of your data
  • Right drag anywhere on the spreadsheet, and the graphing windows will update with new plots.
  • 3D diagram window

  • Freely rotate and zoom 3D plots by dragging the plot and using the scroll wheel respectively. (the plot will keep refreshing while you're rotating).
  • Right drag on a data point, and the corresponding cell in table will be selected
  • 2D diagram window

  • Hover your mouse on a data point in the 2D graph, its information will be displayed at the bottom of the window. (Right drag on the data point, and the corresponding cell in table will be selected).
  • Scroll the 2D graph, and the spreadsheet window will scroll automatically to match the graph you're seeing.
  • Draw cross hairs by right clicking on graph and selecting "set markers"
  • Pin data series down by clicking on the colour index.
  • Return to Index