Section 9: Configuring a Bubble Chart and Raw Data Link
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 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.
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 |
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.
Click Finish.
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.
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.
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.
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.
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.
Adjust Axes
Under the Presentation tab, Axes group, and the Left Axes. Uncheck the Show Tick Labels check box. Next Select Bottom Axes, uncheck the Auto Generate for Min, Max, and Step and set to 1,4,1 respectively. Additionally, set the Left Margin and Right Margin to 20 under the Layout Group.
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.
Your page will look like this:
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: