Grid Surface Chart for SharePoint

Grid Surface Chart

Grid surface charts are a type of data visualization that represents three-dimensional data, where data points are organized in a grid. The data points in each row and column in the grid share the same x and z values, whereas the y value is specified per data point. A variation of the grid surface allows the user to specify a color for each data point thus adding a fourth dimension to the plot. This type of chart is often used to visualize continuous functions or data sets that vary across an area of interest, such as terrain data, surface temperature data, and others.

Grid Surface Chart Gallery

Sample Table Format

Y \ X0123
042576851
163819472
255768864
337496145

The data for a Grid Surface chart is organized as a table, where each cell contains an elevation value.

The row and column headers represent the corresponding grid indexes (0, 1, 2, 3), defining the position of each point on the X and Y axes. The elevation values determine the height of the surface at each grid position, which is then used to create the connected three-dimensional surface.

Best Practices for Using Surface Charts

Choose the Right Chart Type
Surface charts are ideal for visualizing data with variable elevations and regularly spaced X/Z coordinates. If the data does not meet these criteria you can consider using the Mesh or Triangulated surface charts.

Use Appropriate Lighting
Lighting can significantly impact the appearance of Surface charts. Use lighting that highlights the important aspects of the data, such as areas of high or low value that don't obscure any important details.

Simplify the Data
Grid Surface charts can contain millions of data points, and rendering such a large number of data points, especially interactively is very computationally expensive. You can use various methods to simplify the rendered data set like binning or clustering, which are built into the chart.

Use Appropriate Labeling
Labeling ensures the viewer understands the presented data. Label the axes and provide a legend explaining the meaning of any color schemes used in the chart.