How to configure Scatter, Radar, Funnel, and Polar Chart Types in Chart Plus 4.0

The way each chart type displays data varies depending on the specific purpose of the chart. In the latest release of Chart Plus we provide new charts, including: Scatter, Polar, Radar and Funnel. Scatter Chart is similar to Line Chart, but helpfully displays data points. Radar Chart has a sequence of equiangular spokes, similar to a spider’s web, so that a line is drawn connecting the data values for each point. Polar Chart is a circular graph on which data points are displayed using the angle, beginning from the center point. Funnel Chart is similar to a 100% Stacked Column chart and displays values as progressively decreasing proportions, amounting to 100% in total. In this article, we will give you a step–step guide to setting up and configuring the charts.

Scatter chart type

Scatter charts are useful for showing the relation between different sets of data, although it is the same line chart. And you can see additional information in the form of tooltips when you hover over any relevant area.

Step 1: Select Chart Setup section: Chart Type tab: Scatter

Simply choose the type you require, as below: 

Step 2: Select Chart Options tab

The Data Label option under Y(Value)Axis should apply to both the X-Axis and Y-Axis values for scatter charts. However, Bubble Chart only has “Y” value displayed in data label and the tooltips should follow the “x, y, Size: z” format.

For Scatter Chart or Scatter Line Chart or Scatter Spline Chart, X (Value) Axis field can be either Date/Time or Numeric field only and Y (Value) Axis Series can only be numeric field. 

For Bubble Chart, X (Value) Axis field and Y (Value) Axis Series and Z (Size) Value field can only be numeric field types.

Step 3: Customize value of X-Axis and Y-Axis in the X-Axis tab and the Y-Axis tab.

The X-Axis tab for scatter charts should mimic the Y-Axis tab settings, with the exception of “Display Data Labels” (Y-Axis only). 

Step 4: To complete Scatter Chart, check Display Quadrant Line option in the Advanced Settings tab (in the Display tab). 

And then you’ll see:

Radar chart type

A radar chart is a useful way to display multiple data in the form and values represented on axis starting from the same point.

Step 1: Select Chart Setup section: Chart Type tab: Radar

Simply choose the type you require, as below: 

Step 2: Select Chart Options tab

X (Value) Axis field has all fields and Y (Value) Axis Series can only be a numeric field. And the Secondary Axis option is removed under Y (Value) Axis settings. 

Step 3: Customize value of X-Axis and Y-Axis in the X-Axis tab and the Y-Axis tab.

The X-Axis tab settings should include the options Display X-Axis Labels, Display Major/Minor Gridlines, Category X-Axis Labels and Sort. The “Primary Y-Axis Configuration” and “Secondary Y-Axis Configuration” options are removed from the Y-Axis tab because the chart does not display vertical bars and nothing else should change. However you will notice the “Display Major Gridlines” option is selected default for both X-Axis and Y-Axis tabs to show the background chart. 

And then you’ll see:

Polar chart type

Polar Chart displays multivariate data, all starting from the same point. The X axis is located on the boundaries of the circle and the Y axis connects the center of the circle with the X axis.

Step 1: Select Chart Setup section: Chart Type tab: Polar

Simply choose the type you require, as below: 

Step 2: Select Chart Options tab

The Secondary Axis option is removed under Y (Value) Axis settings as Radar because it does not support a secondary axis. 

Step 3: Customize value of X-Axis and Y-Axis in the X-Axis tab and the Y-Axis tab.

The X-Axis tab should mimic the Y-Axis tab settings but should include the options: Data Type Settings, Display X-Axis Labels, Display Major/Minor Gridlines. The “Primary Y-Axis Configuration” and “Secondary Y-Axis Configuration” options are removed from the Y-Axis tab because the chart does not display vertical bars and nothing else changes. However you will notice the “Display Major Gridlines” option is selected default for both X-Axis and Y-Axis tabs to show the background chart. 

The data labels and tooltips format should also follow the same logic as scatter charts (“x, y”). The ‘Display Data Label’ setting should only be available from the Y-Axis tab and apply to both the x and y data labels (same logic as scatter charts). And then you’ll see:  

Funnel chart type

The size of the area is determined the series value as a percentage of the total of all values. Any funnel consists of the higher part called head and the lower part referred to as neck.

Step 1: Select Chart Setup section: Chart Type tab: Funnel

Simply choose the type you require, as below:

Step 2: Select Chart Options tab

The Legend Title and Secondary Axis options are removed under Y (Value) Axis settings because they are not necessary as these charts do not contain an Axis line. And Funnel charts only allow 1 series, so we should not display the Add Series button. 

Step 3: Customize value of X-Axis and Y-Axis in the X-Axis tab and the Y-Axis tab.

The X-Axis tab should include Legend Title and Sort as Pie charts. 

The Y-Axis tab should include Data Type Settings, Labels Position and Display Units as Pie charts. However, Labels Position drop down contains Center, Left, and Right.  

And then you’ll see:


All SharePoint Versions

The web parts are functional components that extend your SharePoint environment whether it’s hosted, on-premises, or part of Microsoft® Office 365.

SharePoint 2013, 2016, 2019, Online (Office 365)

On-Premises Only

These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.

SharePoint 2013, 2016, 2019

SharePoint

Product Suites

Experience greater power and savings by bundling our SharePoint apps and web parts.


Essentials Suite


Essentials Plus Suite


Bamboo Premier Suite


Project Management Suite


Knowledge Management Suite


External User Manager


 

For more information on our product suites, contact us.

Featured Services

SharePoint Health Check

A SharePoint Health Check will identify the causes of issues and risks associated with your specific environment, and is custom tailored to provide you with the best recommendations to optimize your SharePoint environment.

SQL Health Check

Document recommendations relating to performance, stability, availability, or a specific focus you request of your SQL Server database instances.

My SharePointXperts

The truth is that each SharePoint skill may not be a full time job for many organizations, and it is nearly impossible for one person to do everything you need – so augment your team with SharePointXperts; providing the skill sets you need when you need them!