Surface Chart

Description:

Surface Chart (Grid Chart) Excel Add-in visualize data series on a surface.

Mathematician and statistician use this chart for special data analysis.

X and Y axis is better described as data category than data value since values for the X-axis and Y-axis need to have equal distance in each step to form a surface. X, Y values can be constructed by using Matlab mesh-grid function or some other equivalent functions. Z value is represented a testing function that is visualized in the chart.

There is only one set of sample data in this add-in. The user can click “Insert Sample Data” button to insert the data and draw the chart, then follows the format to build own data.

3 columns of numeric data are required. The user can change the text in the column title from “X”, “Y”, “Z” to anything as preferred.

Features:

• Easy to use: sample data show the data format and X, Y values features.

• Easy to rotate the chart from different angle by holding down the left mouse button while moving the mouse.

• Mouse over the chart to view the tool-tip showing the data detail.

• Click the chart title area to enter a preferred

• Customizable X-axis, Y-axis, Z-axis label by updating the title of the columns.

• Zoom in and out the chart by changing the "View Distance" setting.

• 2 chart styles: Grid and Surface.

• Customizable Z-axis value ratio.

• Interactive Chart: the chart is binding to the data table in the sheet. The chart is updating when the data is entered.

Instruction:

• Download this add in and start Excel 2013 SP1 or later.

• Click insert sample data button.

• Adjust setting to view the chart update.

• Build own data and paste into sample data table and click binding existing data button to draw the chart.