Correlation Matrix Chart

Description:

Correlation Matrix Chart add-in is visualize the correlations between data pairs in the data series with 3 types of trend-line.

This add-in can analyse the relationship between the data series and find the correlation between each pair of variables.

Supported data structures for this addin:

• Title row: a string array for the category of each data series.

• Column 1: a string for the item name of each row.

• Column 2-n: numbers (n<=10).

There are 2 sample data provided in this add in:

• International city economic statistics data.

• A portfolio/watch performance data.

The chart has a data filter. The user can select a column in the setting winow for the data filter. The user can slide the filter to redefine the data range drawn in the chart.

The user can add a trendline to the chart to observe the fitness of the data. 3 types of trendline are provided:

• Linear [#LI]Exponential [#LI]Polynomial Features: [#LI]3 types of trendline. [#LI]Select data column for the filter to filter out outlier. [#LI]Mouse over the chart to view the data detail in the tool-tips. [#LI]Easy to use and user friendly are the key features of this add-in. Sample data can be the template to build own data. [#LI]Although this add-in can be an interactive chart, when the user have large data set to draw, we recommend the user stay on the setting window while updating the data. And clicking the binding to existing data button to redraw the chart after updating the data. Instruction: [#LI]Download this add in and start Excel 2013 SP1 or later. [#LI]Click Insert Sample Data button to insert the sample data and view the chart. [#LI]Build own data and follow supported data structure above, then paste into the sample data table to replace the sample data. Add more columns in the spreadsheet table when there are more time series data.. [#LI]Click in the title area in the chart to enter desired title.