Bubble Charts in Excel and Excel Services

Creating Bubble Charts is one of the biggest challenges in Excel and Excel Services with respect to data visualization.  Microsoft made it very intuitive in PowerView and very not intuitive in Excel.  Frankly, the way this functionality is implemented in Excel makes it practically unusable.  Rumor has it that this area is getting a lot of love and attention in the new release of Microsoft Office (commonly known now as Office 15) but for now we do need some help with building this in the Excel Services supported way.

Microsoft has posted an example of how to do bubble charts in excel so that it will be suitable for Excel Services.  You can find a link to the excel file here. It took me a while to figure out how the file is set up. So to get a quick jump-start on it, take a look at all of the name ranges defined and also click the bubble chart and then on Chart Tools->Design-> Select Data button on the ribbon and then Edit on the Pop up Window to see how those named ranges are being used in the chart.

Not easy and user-friendly, but it works and will provide a much-needed relieve until the new features come out with the new release of Microsoft Office and SharePoint.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s