|  | 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