Wednesday, December 15, 2010

Plotting data on Bubble charts

In this post I will be helping you to plot bubble chart on Microsoft Excel. It is really easy to plot data on bubble charts. First of all, your data must contain atleast three to four rows and columns because if it contains lesser rows than the chart does not plots the bubbles correctly.The various steps for plotting data using bubble charts on Microsoft Excel is as follows:
1. Select the data that you want to plot on Bubble chart.(It is good if you don't include the row and column headings while selecting the data as selecting row and column headings may give incorrect bubbles).
2. Go to Insert tab, on the Charts group select Other Charts.
3.Under Bubble, click Bubble with a 3D- effect.
4. Click the chart area of the chart. This displays the Chart Tools, adding the Design, Layout and Format tabs.

5. On the Design tab, in the Chart styles group, click the chart style that you want to use.

This is an easy way to design out your data on Bubble charts.Use it.It makes your data interesting and presentable.
Enjoy BubbliNg!!!

No comments:

Post a Comment