Day 7 - Team H

Bubble chart:

A Bubble chart is a variation of a Scatter chart in which the data points are replaced with bubbles. A Bubble chart can be used instead of a Scatter chart if your data has three data series, each of which contains a set of values

Creating a Bubble chart:

Step1. Let’s set up our table first. I used the "Series Name", "X axis", "Y axis", "Bubble Size" convention Series Name X-axis Value Y-axis Value Bubble size A 1 3 5 B 0.5 0.8 50 C 1.5 2 10

Step2. without selecting the table, insert a bubble chart

Step 3. While the empty chart is selected, hit select data. The following menu will pop up:

Step 4. hit add, then this will pop up:

Step 5. Now, you have to enter four data points for each series. Once one is entered, repeat step 4 until all of your data has been entered into the chart.

Formatting Bubble charts

There are several ways to change the format of a Bubble chart:

Display bubbles with a 3-D visual effect     By selecting the 3-D Bubble chart sub-type, bubbles are formatted with a 3-D visual appearance.

Adjust the size of bubbles     The size of the bubbles can represent the area of the bubbles or the width of the bubble, which affects the relative size of one bubble to another.

Change the color and pattern of bubbles

1. In the Bubble chart, select a bubble or bubble series.
2. On the Format menu, click Selected Data Point or Selected Data Series.
3. On the Pattern tab, select the options you want.
4. To change the gradient, texture, or pattern of bubbles, click Fill Effects, and then select the options you want on the Gradient, Texture, or Pattern tab.

When to use a Bubble chart:

Use a Bubble chart when you want specific values to be more visually represented in your chart by different bubble sizes. Bubble charts are useful when your worksheet has any of the following types of data:

• Three values per data point     Three values are required for each bubble. These values can be in rows or columns on the worksheet, but they must be in the following order: x value, y value, and then size value.
• Negative values     Bubble sizes can represent negative values, although negative bubbles do not display in the chart by default. You can choose to display them by formatting that data series. When they are displayed, bubbles with negative values are colored white (which cannot be modified) and the size is based on their absolute value. Even though the size of negative bubbles is based on a positive value, their data labels will show the true negative value.
• Multiple data series     Plotting multiple data series in a Bubble chart (multiple bubble series) is similar to plotting multiple data series in a Scatter chart (multiple scatter series). While Scatter charts use a single set of x values and multiple sets of y values, Bubble charts use a single set of x values and multiple sets of both y values and size values.

Sources:                                     

http://office.microsoft.com/en-us/excel-help/creating-a-bubble-chart

http://www.sccs.swarthmore.edu/users/06/adem/engin/excel/bubble_chart/index.php

Name: Balram Singla