Archive

How To Create Pair Chart Using xlChart+ Add-in?

Flowing these steps to create pair chart:

First, select data in the worksheet.

Click “Pair” item in “Compare Means” menu in xlChart+ add-in, open “Create a Pair Chart” dialog box. Input “C2:C11” in “Grouped Range” textbox.

Click “OK” button.

You can also create other types of pair charts.

How To Create Scatter+Boxplot Chart Using xlChart+ Add-in?

Flowing these steps to create scatter+boxplot chart:

First, select data in the worksheet.

Click “Scatter+Boxplot” item in “Compare Means” menu in xlChart+ add-in, open “Create a Scatter Boxplot Chart” dialog box. Input “B1:B90” in “Grouped Range” textbox.

Click “OK” button.

You can change the colormap by selecting another item in “Select a colormap” dropbox in “Create a Scatter Boxplot Chart” dialog box.

How To Create Scatter+Bar Chart Using xlChart+ Add-in?

Flowing these steps to create scatter+bar chart:

First, select data in the worksheet.

Click “Scatter+Bar” item in “Compare Means” menu in xlChart+ add-in, open “Create a Scatter Bar Chart” dialog box. Input “B1:B90” in “Grouped Range” textbox.

Click “OK” button.

You can change the colormap by selecting another item in “Select a colormap” dropbox in “Create a Scatter Bar Chart” dialog box.

How To Create Cloud Rain Chart Using xlChart+ Add-in?

Flowing these steps to create cloud rain chart:

First, select data in the worksheet.

Click “Cloud Rain Chart-Type 1” item in “Cloud Rain Chart” menu in xlChart+ add-in, open “Create a Cloudrain Chart” dialog box. Input “B1:B90” in “Grouped Range” textbox.

Click “OK” button.

You can change the type by selecting another item in “Type” dropbox in “Create a Cloudrain Chart” dialog box.

How To Create Violin Chart Using xlChart+ Add-in?

Flowing these steps to create violin chart:

First, select data in the worksheet.

Click “Violin Chart-Type 1” item in “Boxplot Chart” menu in xlChart+ add-in, open “Create a Violin Chart” dialog box. Input “B1:B90” in “Grouped Range” textbox.

Click “OK” button.

Select “Type 2” in “Type” dropbox in “Create a Boxplot” dialog box, click “ok” button.

How To Create Boxplot Chart Using xlChart+ Add-in?

Flowing these steps to create boxplot chart:

First, select data in the worksheet.

Click “Boxplot Chart-1 Color” item in “Boxplot Chart” menu in xlChart+ add-in, open “Create a Boxplot” dialog box. Input “B1:B90” in “Grouped Range” textbox.

Click “OK” button.

You can change the colormap by selecting another item in “Select a colormap” dropbox in “Create a Boxplot” dialog box.

How To Create Triangular Square Heatmap Chart Using xlChart+ Add-in?

Flowing these steps to create triangular square heatmap chart:

First, select data in the worksheet.

Click “Triangular Square Heatmap Chart” item in “Heatmap Chart” menu in xlChart+ add-in, open “Create a Heatmap Chart” dialog box. 

Click “OK” button.

You can change the colormap by selecting another item in “Select a colormap” dropbox in “Create a Heatmap Chart” dialog box.

 

How To Create Square Heatmap Chart Using xlChart+ Add-in?

Flowing these steps to create square heatmap chart:

First, select data in the worksheet.

Click “Square Heatmap Chart” item in “Heatmap Chart” menu in xlChart+ add-in, open “Create a Heatmap Chart” dialog box.

Click “OK” button.

You can change the colormap by selecting another item in “Select a colormap” dropbox in “Create a Heatmap Chart” dialog box.