When Completed

Your NetCharts Designer perspective will appear like this:
 

Getting Started

Start by closing any open editors. Go to NetCharts Designer’s File menu and select the Close All option.
 
Next, create a new project named RadarChartProject.

Create Data Set

Bring up the Named Data Set (NDS) wizard by selecting on the NDS icon. Set the Named Data Set Name to data and select the Hypersonic SQL option.
Select Next. Click the ellipsis button, and type in the following query in the SQL field:
 

SELECT Location, Sum(Actual)/1000000 as Actual, Sum(Budget)/1000000 as Budget FROM BUDGETDATA WHERE Caffeinated = ‘All’ AND Location NOT LIKE ‘All’ Group by Location

Click Finish. The data editor will be shown. Next we need to transpose the data so that we have the data in the correct format for a radar chart. Click on the Functions tab and in the Data Pivot group, check the Transpose checkbox.
 

Create the Radar Chart

Select the New Chart wizard icon from the tool bar. After the wizard appears, type in chart as the Chart Name, and select Radar as the type.
 

 
Select the Finish button to create the chart and display the radar chart editor.
 

Bind Radar Chart Data

Select the Data Source Binding tab. Click on the Lines node in the tree control. Select the data.ndx file from the Data Sources menu. Set the menu above the last four columns to Axis Points and the click the Select Rows button. Check the Process Row‐Major checkbox.

Select the Axes Titles tree node, select data.ndx for the Data Source, set the last four columns to Title, check Row 0, and check the Process Row‐Major checkbox.
 

 
Select the Legend Items node, select data.ndx for the Data Source, set Column 0 to Legend Items, and check Row 1 and Row 2. Lastly, uncheck the Process Row Major check box.
 

Configure Radar Axis

Click on the Presentation tab and select Axes. Click on the X on Axis 5 and click Yes when presented with the confirmation dialog to delete Axis 5.
 
Next, we are going to set up all of the scales on the four remaining axes. Select the tab for Axis 1 and set the Min to 0, the Max to 2, and the Step to 2. Choose dollars for the Number Format. Repeat these same steps on Axes 2‐4.
 

Configure Line Sets

Up to this point, only one lineset has been showing although two have been set up. We will need to configure the display characteristics for both. Select the Lines node from the tree control.

Click on the New Line Set button to add another line set, if two sets are not present. Select the Line Set 1 tab. Change the Line to basicblueline_v7. Click on the pencil icon, in the Background Fill drop down menu, change the Fill Type to solid, change the color to the same blue color as the line, and change the Fade to 60%. Click OK. Select the Line Set 2 tab. Change the Line to basicgreenline_v7. Click on the pencil icon, in the Background Fill drop down menu, change the Fill Type to solid, change the color to the same green color as the line, and change the Fade to 60%.
 
Next select the Legend tree option to view the legend options. Check Show Legend, set the Location to Top and
Layout to Horizontal.
 
Additionally, add a Title to the chart that says Actual vs. Budget (M). The radar chart now shows where the Divisions are failing to meet their budgets; South America is under budget, whereas Asia is over.