Data Distribution Chart

Description:

Data Distribution Chart (Box Chart) Excel Add-in is a tool to visualize the data distribution in minimum, maximum, median, 1st quartile, 3rd quartile.

The data are organized by row that 1st column has the series name. The rest columns have the instances of the data cross the timeline or other attributes such as numbers.

Two sample data help user to understand the data structures.

• Insured Unemployment Rate by State: (the data comes from US. Bureau of the Census). In the chart, you can view the insured unemployment rate in selected states and its variation between the min, max, media, 1st quartile, 3rd quartile.

• Security Comparison Sample Data: It shows several securities return distribution for a better security selection.

Features:

• The box and whisky show the min, max, median, 1st quartile, 3rd quartile of the data series by rows in the data table in the sheet.

• Mouse over the boxes to view the data detail in the tool-tips.

• The user can change the chart title by clicking in the title area and enter a new text for the chart title.

• Easy to use and user friendly. Sample data can be the template to build own data.

• Interactive Chart: the chart is binding to the data table. The chart is updating when the data is entering.

Here is a link to help to read a box chart.

Instruction:

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

• Select a sample data type in the sample data drop-down in the setting window and Click Insert Sample Data button to view the chart.

• Clean the sample data and set the focus to the first cell.

• Select a different sample data in the setting window and view the chart.

• Repeat step 2, 3, 4 and view all the 4 different type of sample data.

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