Bubble Chart Pro™ PLUS gives you lots more than just beautiful bubble charts. Bubble Chart Pro™ PLUS is a graphical analytical tool with a built-in SMART project ranking system to let you rigorously prioritize your projects and visually view the results in bubble charts, bar charts, and sensitivity charts.
Bubble Chart Pro with 3D bubble charts comes in three editions. Bubble Chart Pro BASIC is the basic bubble charting application, and includes fully customizable 2D and 3D bubble charting capabilities. Bubble Chart Pro PLUS includes a SMART prioritizer for prioritizing or ranking projects, project bar charts, and an executive dashboard. Bubble Chart Pro™ PLUS is a graphical analytical tool with a built-in SMART project ranking system to let you rigorously prioritize your projects and visually view the results in bubble charts, bar charts, and sensitivity charts. Easily rank your projects using the automatic SMART project prioritization system developed by scientists at Harvard, MIT, and the University of Southern California. A prioritized project portfolio bubble chart. The projects are ranked by SMART value scores. When you are building advanced charts using SQL queries, Chart query is used to build the charts and Result query is used to show in-depth information on click. Aliases that can be used in Bubble chart are xvalue and yvalue. The chart will be plotted based on these values in x-axis and y-axis. Bubble Chart Pro Optimal also comes with a lot of helpful features that make your business analyses easier than ever, including interactive chart bubbles, 'zoom boxes' for zooming-in and expanding.
Bottom line: Just one analysis using Bubble Chart Pro™ PLUS could easily save you hundreds or thousands of times the purchase price!
Click here to go to the Optsee® website and sign-up to try the Optsee® Basic demo. Optsee® Basic has all the features of Bubble Chart Pro PLUS and more. Click here to view the comparison chart.
The world’s largest technology companies, titans like IBM and Apple, believe in a culture of design, with an emphatic focus on people-centered products and services being the best way to deliver products quickly and at scale. This design-first principle is an important component of data analysis and visualization.
Data analysis is about understanding, preparing, and validating the data. However, visualizing data to communicate stories and spot trends adds the design-first principle. A bubble chart is a type of data visualization that, when applied correctly and designed effectively, is a great way to take a design-first approach to presenting data.
In this article, learn why bubble charts are a useful tool for data visualization. Use the on-page navigation to jump ahead for tips on when, why, and how to use bubble charts, including a list of various software tools that exist for all levels of technical proficiency. Plus, get started creating basic bubble charts using Microsoft Excel 2016 by the tutorial provided.
In a design-first, technology-driven world, using visualizations like bubble charts to communicate a people-centered story is paramount. Bubble charts have the potential to compress and condense large datasets for hundreds, sometimes thousands of data points in a single view.
While scatterplot chart is ideal for showing the correlation between two values, a bubble chart adds a third dimension to visualize data, either in small multiples or across a few variables. Bubble charts are optimal for showing the relationship between data using the size of the data plot as the third visual element. The data is plotted and displayed using bubbles, or categorized circles (discs).
Instead of traditional charts that use two axes (x and y) such as column or line charts, bubble charts display a third dimension of data (sometimes referred to as the z-axis). The x- and y-axis of a bubble chart are numeric, not categorical, so the position of the data plotted is an indicator of two values. A bubble chart is capable of presenting four dimensions of data. The color (or color temperature) of the data bubble is the fourth dimension used to differentiate data points.
Bubble Charts for Sales and Marketing
Bubble charts, like all data visualization, are a form of storytelling. Sales and marketing professionals use data visualization to gain insight and communicate using raw data. A marketer might use bubble charts in a presentation instead of a list of bullet points to describe key advertising metrics that include multiple data series across different time periods. A single chart on a single slide tells the story of top-performing digital marketing campaigns that emphasize ROI from different online segments.
Watch the demo to see how you can more effectively manage your team, projects, and processes with real-time work management in Smartsheet.
Bubble charts create a digestible story for the viewer, providing a quick assessment of the relationship between different data — something bar and line charts don’t always accomplish. A bubble chart visually explores correlation (or association) between data.
Well designed bubble charts effectively display three fields of data using the position and proportion of the bubbles plotted. This type of chart is a helpful tool for analyzing data sets with multiple inputs, visualizing patterns, and finding trends using data analysis. For example, a period of time (x-axis), a value figure (y-axis), and a percentage of growth (bubble size).
A bubble chart is a dynamic tool for analyzing finance scenarios beyond standard time-series or whole-to-whole comparisons using line and bar charts. For example, comparing investment returns using formula-driven data from spreadsheets, over a period of time, for multiple categories of investments (mutual funds, index funds, stocks, bonds, etc.).
It is easier to explore the correlation between ROI and the investment category when the data appears in a bubble chart instead of presenting it linearly. Bubble charts contribute to the storytelling element of visualization for finding correlation for a data series.
The bubble chart is an effective data visualization tool. However, like other charts and reports, a bubble chart is only as compelling as the data it represents.
Remember to keep the purpose of a bubble chart in mind before plunging forward with the work. If you have multiple data series that tell a story, or you’re looking for insight from your data and need to visualize the relationship between different data sets, consider using a bubble chart.
Here are some additional tips to consider when deciding whether a bubble chart is the right visualization to use.
This section is a step-by-step tutorial on creating a bubble chart and plotting data using Microsoft Excel 2016 (Office 365 edition). We adapted the data for this tutorial from a Google Analytics demo account for the Google Merchandise Store. Follow the steps below to create the bubble chart shown in this image:
Insert Bubble Chart
Open the Excel spreadsheet with your data and click Insert from the menu. Hover and click the drop-down menu arrow for Scatter (X, Y) or Bubble Chart from the Charts sub-menu. There are two options under Bubble — standard Bubble or 3-D Bubble. This tutorial uses the standard Bubble option, so click Bubble. A blank square will appear on the spreadsheet.
Add Data Sources
Right-click the chart and click Select Data from the menu.
From the Select Data Source window, click the Add button under the Legend Entries (Series) section.
Edit Data Series
To edit data previously added to the bubble chart, click Edit from the Select Data Source window. Click on the appropriate data in the spreadsheet that corresponds to each series cell listed in the Edit Series window:
Click on the data or (type the name) of the series in the Series name cell.
Click on the data for the x-axis in the Series X values cell.
Click on the data for the y-axis in the Series Y values cell.
Click on the data for the z-axis (or size) of your bubble chart in the Series bubble size cell.
To make changes to existing data series, click Edit in the Select Data Source window. Click the OK button to finalize the data source selections and return to the inserted bubble chart.
Click Add to include multiple data series in the bubble chart and repeat the Edit Series steps above for each new Legend Entry (Series). Add the data for Organic Traffic and Direct Traffic which will place more than one bubble on the chart.
Format and Design
The final step to creating your bubble chart is formatting the data and adding design elements like axis titles and data labels. This step turns a raw bubble chart into a compelling data visualization. Size, color, and various formatting choices help make the chart more visually appealing.
Excel generates automatic axes and unit intervals based on the data series for the bubble chart.
To change Axis Options like bounds and unit intervals double click on the vertical y-axis area of the chart and use the Format Axis menu.
For this tutorial, we’re changing the Bounds > Minimum to zero, but you can click on the tabs (Fill & Line, Effects, and Size & Properties) to make other alterations.
Repeat this step to format the Axis Options for the horizontal x-axis by double clicking the bottom area of the graph.
For this tutorial, we are also changing the Bounds > Minimum of the x-axis to zero (shown below).
Add Chart Style and Elements
Click the bubble chart and the Design sub-menu options appear in the top ribbon. Select a pre-formatted Chart Style or click the Add Chart Element and click options like Chart Title, Legend, and Data Labels to make adjustments.
There is a shortcut to the Chart Elements. Click the bubble chart and three icons appear on the right. Select the Chart Element icon to add or remove elements like Axis Titles, Gridlines, and Error Bars.
For Microsoft Excel 2013, click the Design tab and click Add Chart Element. Select from Centered Overlay or Above Chart options from the Chart Titles option.
Excel Bubble Chart Template
To save time and experiment with different styles and formats, save your bubble chart as a template in Excel. Right-click the bubble chart and click Save as Template. Name the chart template in the File name cell. Click Save.
Microsoft Excel is one of many software tools you can use to create and manage bubble charts. The market for data visualization tools continues to evolve and offer features that provide new ways of turning raw data into a compelling message.
Software engineers create web-based bubble charts with different programming languages instead of a graphics-based interface like the previously listed bubble chart makers or spreadsheet software. If you have the technical proficiency, or just want to practice creating bubble charts by writing code, here’s a list of data visualization tools that software engineers use:
ChartFX: Business intelligence and data visualization for developers from SoftwareFX. ChartFX emphasizes visualization and data analysis with tools such as OLAP and IDE integrations that span seven development platforms including Microsoft Visual Studio, Java, HTML5, and iOS.
Python Graph Gallery: Developed and managed by Yan Holtz, this project is an online gallery to promote data visualization with Python. This graph gallery features hundreds of Python charts, including scatterplot and bubble charts, all with associated reproducible Python code.
Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change.
The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed.
When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time. Try Smartsheet for free, today.