A Bubble Chart is a diagram that presents multi-dimensional data in a graphical form. Each data field is tied to a particular visualization. Most often data controls the Size and Position of elements in the chart. Thus the diagrams often resemble a bunch of bubbles. Taken to an extreme, data can be visualized in almost any way such as Color, Shape, Line Thickness, Shadow or any other formatting. As the data grows more complex, it becomes more important to find effective ways to present it. Bubble charts offer a compact graphical way to present information.
Over the next few posts we will build our very own Bubble Chart stencil. Using the custom Bubble Chart shapes in combination with the Data Link and Data Graphics features of Visio 2007, it is possible to generate Bubble charts from data in just a few steps. In this post we look at the finished solution from a user perspective. The Bubble Chart stencil is included as a file attachment to the post. In subsequent posts, we create the stencil from scratch. Understanding the details of construction will let you customize the solution if you desire.
Using the Bubble Chart stencil
To make a bubble chart, you need the BubbleChart.vss stencil and a data source with data in specially labeled fields. Here is an Excel spreadsheet with the data we will use. Note the column headings: Label, X, Y and Size. Our bubble chart shapes are designed to pull information from fields with these names.
To begin, start a new blank drawing and open the BubbleChart.vss stencil. Go to Data > Link Data to Shapes to import the data from Excel. In the Data Selector wizard, choose Microsoft Excel Workbook. Then browse to the Excel file and click Finish. The data appears in the External Data window.
Next drag the Bubble Chart shape onto the page. This shape forms the chart background. It includes labels for the title and axes. The chart shape defines the space where bubble shapes will be placed. As the chart is moved or resized, the bubble shapes will reposition accordingly. Dropping the shape automatically triggers the Shape Data dialog. Fill in the ranges and labels for each axis. The last Shape Data field is Max Size. Enter the largest Size value you expect in your data. Visio will scale the bubbles to make the largest size equal to 1 inch on the page.
Now we are ready to add the bubbles. Select the Bubble Data shape in the Shapes window, but do not drag it onto the page. Instead click on a row in the External Data window and press Ctrl+A to select all the data rows. Then drag the rows onto the page. Data Link drops new Bubble Data shapes and automatically links them to the data. The bubble shapes are placed into the chart according to their data values. The Label and Size fields are displayed as data graphics. The diagram is complete! You can even use the Data Refresh feature to quickly update the diagram when the Excel data changes.
Connect to your data set. Add the Bubble Chart shape. Select the Bubble Data shape and drag out all the data rows. Instant diagram. Next time we'll see how to build the BubbleChart.vss stencil to make it happen.
Is this a continuation of Chris Castillo's Bubble chart that Mai-Lin bloogged about?
Actually, I see it as the Visio 2007 way of doing a Bubble Chart. With Visio 2007 Pro's Data Link feature, you can visualize more dimensions using Data Graphics.
In the Visio 2003 Bubble Chart add-in I created (search on GotDotNet), I had to code what you get for free in Visio 2007. It had code to read from Excel, color shapes, etc. In Visio 2007, you just need this stencil! Use the out-of-the-box feature to link to Excel data. If you want color, icon sets, or data bars, you can use Data Graphics. You can virtually visualize as many dimensions as you want!
(I think a screenshot should be added to show what a diagram could look like with Color By Value or data bars.)
This is awesome - how do i get a copy of the bubblechart.vss as its not showing up clicking on the link. I would love to play with this as it may be what i have been looking for. Thank you so much for your help and this awesome and easy looking tool,
To get the bubble chart stencil, just click on the BubbleChart.vss link in the Attachments of this blog entry. Save it under My Documents\My Shapes. Then, go to Visio and create a new document. Open the Bubble Chart stencil by clicking File-->Shapes|My Shapes|BubbleChart.
Hope this helps,