Archive

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

Flowing these steps to create heatmap chart:

First, select data in the worksheet.

Click “Circle 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 Normal Heatmap Chart Using xlChart+ Add-in?

Flowing these steps to create heatmap chart:

First, select data in the worksheet.

Click “Normal 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 Scatter Chart” dialog box.

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

Flowing these steps to create regular scatter chart:

First, select data in the worksheet.

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

Click “OK” button.

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

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

Flowing these steps to create jittered scatter chart:

First, select data in the worksheet.

Click “Jitter Scatter” item in “Scatter Chart” menu in xlChart+ add-in, open “Create a Jittered Scatter 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 Chart” dialog box.

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

Flowing these steps to create scatter chart:

First, select data in the worksheet.

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

Click “OK” button.

You can also create complex scatter chart following these steps:

Select data.

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

Click “OK” button.

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

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

Flowing these steps to create ridge chart:

First, select data in the worksheet.

Click “Ridge” item in “KDE Chart” menu in xlChart+ add-in, open “Create a Ridge Chart” dialog box. Input “B1:B800” in “Grouped Range” textbox.

Click “OK” button.

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