Section 9: Configuring a Bubble Chart and Raw Data Link

NOTE: Bubble charts provide an excellent way to view data in three dimensions. In the following tutorial we will create a bubble chart that visualizes financial data by overlaying two datasets. Bubble Charts allow the plotting of 2 vectors of data using an X (Horizontal) axis and a Y (Vertical) axis positions just like a scatter, or X-Y chart. However a third vector of data can be plotted represented by the size of the bubble. Additionally, the color/fill pattern, outline color and outline style of the bubble can represent 3 additional less complex vectors of data.
NOTE: A Raw Data Link allows the result set from an .ndx to be extracted either for display or saved to a file.

When Completed

Your NetCharts Designer perspective will appear like this:
 
bubble

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 BubbleChartProject.

Create the Manual Dataset

From the toolbar click on the Create a New Dataset wizard. Name your new dataset BubbleChartData, select Manual Data Entry from the Available Data Sources list, and click Next.
 
bubble
You will be presented with a grid. Copy the following data by dragging your mouse over the table to highlight the data items, and paste it into the data grid in the editing panel using the Paste From Clipboard button. Click Finish.
 

Actual Budget
Jan 1 50 6000 1 50 5000
Feb 2 50 4500 2 50 5000
Mar 3 50 7000 3 50 5000
Apr 4 50 4000 4 50 5000

 
bubble

Create the Bubble Chart

Now that we have created our dataset the next step is to create the bubble chart. From the toolbar click on the Create a New Chart icon. Call it BubbleChart, select Bubble Chart for the type.
 
bubble
 
Click Finish.
 
bubble
 
Under the Presentation tab, under the Bubbles tree node, in the Bubble Sets group, under the Bubble Set 1 tab, in Bubble Style set Bubble Symbol to symbolbubbleblue and Color Table to Undefined. Next in the Bubble z‐Scale group, check the Auto checkboxes adjacent to Min and Max.
 
bubble
 
Click the New Bubble Set button, and in the Bubble Styles group of Bubble Set 2, select symbolbubblered from the Bubble Symbol drop down menu. Edit the style and in the Symbol group, enter a 60% fade to the Fade spinner adjacent to the Color button.
 
bubble
 
Click OK.

Bind Data to the Bubble Chart

Next we must bind our data that we created in Step 2 to our Bubble Chart. Select the Data Source Binding tab and under the Data tree control select Bubble Values. Choose BubbleChartData.ndx as your Data Source. Instead of checking the axis use the filters section and set your column to 1* and your row to 1* by typing these in manually – learning how to use the filters is faster than clicking on check boxes.
 
bubble
 
Next Select Legend Items. Select BubbleChartData.ndx as the Data Source and enter 0-1 for the column filter and 0 for the row filter. Under the Presentation tab, under the Legend tree node, in the Display group, check the Show Legend checkbox.
 
bubble
 
Back under the Data Source Binding tab, expand the Axis Labels group, and select Bottom 1. Select BubbleChartData.ndx as the Data Source and bind the months in Column 0 to the bottom axis.
 
bubblke

Adjust Axes

Under the Presentation tab, Axes group, and the Left AxesUncheck the Show Tick Labels check box. Next Select Bottom Axesuncheck the Auto Generate for MinMax, and Step and set to 1,4,1 respectively. Additionally, set the Left Margin and Right Margin to 20 under the Layout Group.
 
bubble

Raw Data link

Create a page called page.pgl, and drag BubbleChart.cdx onto the page layout. Click OK to the chart’s resource menu. Create a Raw Data Link by either dragging BubbleChartData.ndx over the icon representing BubbleChart.cdx on the page layout, or dragging the Raw Data Link from the pallet on the left over the chart icon the same way. Tile the Raw Data Link object vertically.
 
If you dragged from the pallet, a dialog will launch requesting you identify with which .ndx file to associate with the data link. Choose BubbleChartData.ndx.
 
In the Edit Data Link Properties dialog, choose the Data Link tab. Leave the Raw Data Link type drop down as is, and overtype the Link Label to read Launch Excel in a Browser. Create a Label Style called DataLinkLabelStyle and set the font to 10 point Arial Bold, and color the label blue. In the Target Window Drop Down menu, select New Window. Click OK.
 
bubble
 
Your page will look like this:
 
bubble
 
And when you click on the Launch Excel in Browser link, click the Open button in the File Link Dialog. The following Browser session should appear:
 
bubble