Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Bubble chart

17 Dec 2010   #1
GRoston

Windows 7 x64
 
 
Bubble chart

I would like to use Excel 2010 to create a bubble chart such as this one:


Would you please help me with the following:
1. How can I make each row have a different color?
2. How can I use other than numeric axis labels?

If this is not possible with Excel, please suggest a tool for creating such charts.

Thank you.


My System SpecsSystem Spec
.
17 Dec 2010   #2
Irene

Windows 7 Home Premium 64bit
 
 

The following relates to Excel 2007, but may well apply to Excel 2010, taken from here... Present your data in a bubble chart - Excel - Microsoft Office


Create an elaborate bubble chart


So, how did we create this bubble chart? The following procedure will help you create a bubble chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data.
  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot in a bubble chart.
How to copy the example worksheet data
  • Create a blank workbook or worksheet.
  • Select the example in the Help topic.
Note Do not select the row or column headers.

Selecting an example from Help
  • Press CTRL+C.
  • In the worksheet, select cell A1, and press CTRL+V.

1 2 3 4 5 6
A B C Number of Products Sales Percentage of Market Share 5 $5,500 3% 14 $12,200 12% 20 $60,000 33% 18 $24,400 10% 22 $32,000 42%
Note Make sure that your worksheet has at least four rows or columns of data. When you create a bubble chart from three or fewer rows or columns of data, the chart does not plot the bubbles correctly.
  1. Select the data that you want to plot in the bubble chart.
Note It is best not to include row or column headings in the selection. If you select the headings with your data, the chart may produce incorrect results.
  1. On the Insert tab, in the Charts group, click Other Charts.

  1. Under Bubble, click Bubble with a 3-D Effect.
  2. Click the chart area (chart area: The entire chart and all its elements.) of the chart.
This displays the Chart Tools, adding the Design, Layout, and Format tabs.
  1. On the Design tab, in the Chart Styles group, click the chart style that you want to use.

Tip For our bubble chart, we used Style 29.
  1. On the chart, click the legend, and then press DELETE.
  2. To change the size of the chart, on the Format tab, in the Size group, select the shape size that you want in the Shape Height and Shape Width box, and then press ENTER.
Tip For our bubble chart, we used 3.5" for both shape height and shape width.

  1. To add, format, and position a chart title on the chart, click the chart area (chart area: The entire chart and all its elements.), and then do the following:
  1. On the Layout tab, in the Labels group, click Chart Title, and then click Above Chart.

  1. In the chart, click the chart title, and then type the text that you want.
Tip For our bubble chart, we typed Industry Market Share Study.
  1. To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Size box on the shortcut menu.
Tip For our bubble chart, we used 12.
  1. To align the chart title with the plot area (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.), click the chart title, and then drag it to the position that you want.
  1. To add a horizontal axis title, click the chart area of the chart, and then do the following:
  1. On the Layout tab, in the Labels group, click Axis Titles, and then click Primary Horizontal Axis Title, and then click Title Below Axis.
  2. Click the horizontal axis title, type the text that you want, and then press ENTER.
Tip For our bubble chart, we typed Number of products.
  1. Click the vertical axis, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).
  2. On the Format tab, in the Current Selection group, click Format Selection.
  3. Under Axis Options, do the following:
  • For Minimum, select the Fixed option, and then type 0 (zero) in the Fixed box.
  • For Maximum, select the Fixed option, and then type the number that you want in the Fixed box.
Tip For our bubble chart, we typed 80000.
  1. In the Format Axis dialog box, click Number.
  2. Under Number, in the Decimal places box, type 0 (zero), and then click Close.
  3. To apply a special formatting effect to the plot area, chart area, chart title, or vertical axis of the chart, click that chart element, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box), and then do the following:
  • On the Format tab, in the Shape Styles group, click the More button , and then click the effect that you want to use.

Tip For our bubble chart, we used the Subtle Effect - Accent 4 for the plot area, Intense Effect - Accent 4 for the chart area, Subtle Effect - Accent 4 for the chart title, and Intense Line - Accent 6 for the vertical axis.
  1. If you want to use theme colors different from the default theme that is applied to your workbook, do the following:
  1. On the Page Layout tab, in the Themes group, click Themes.

  1. Under Built-in, click the theme that you want to use.
Tip For our bubble chart, we used the Foundry theme.


I hope this helps - there is more information in the link.
My System SpecsSystem Spec
17 Dec 2010   #3
GRoston

Windows 7 x64
 
 

Irene,

Thanks for the pointer. The referenced article is focused primarily on the aesthetics of a standard bubble chart and does not address either of my questions.

I did figure out the answer to my first question - simply make each row its own data series.
My System SpecsSystem Spec
.

Reply

 Bubble chart




Thread Tools




Similar help and support threads
Thread Forum
How to hide bubble list?
Hello, I am new using 7, i had to transfer from XP to 7. I have various questions about configuration like the following. Has you can see inside the image, there is a list inside a bubble showing up. My question is: How to hide this list? Prevent windows from showing it. Thanks. ...
Customization
bubble dock
Hi guys My friend is not too computer savvy and has finished up installing bubble dock on her machine. I searched and it looks difficult to remove, she tried system restore but still has problems. I think her machine really needs a clean install. Anyone come across bubble dock?
System Security
Excel 2010 Chart Left Axis is in middle of chart
Hi, For some reason, the numbers for the left axis are in the middle of my chart and I have highlighted the axis and reformatted to no avail. How can I change the settings so it is shown on the far left as usual? I've uploaded a jpg showing the problem. A big thanks in advance,
Microsoft Office
BSOD when playing Bubble Safari.
So I was playing Bubble Safari when the computer just went to a blue screen of death. I didn't really see what was going on but I have the files from the SF Diagnostic Tool. If anyone could help me out I would appreciate it. Also I noticed there's nothing different about the computer now that I...
BSOD Help and Support
Laggy Bubble Screensaver
First, here are my system specs: MSI P6N SLI Platinum Motherboard 2 7600 Gt's (SLI) 2 Gigs Twinx DDR2 800 Corssair RAM 2 160 Gig Western Digital Hard Disks (Raid 0)
Performance & Maintenance
Don't burst your Bubble
Just WOw Super-slow-motion pictures show soap bubble bursting in stunning detail | Mail Online
Chillout Room


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 05:31.
Twitter Facebook Google+ Seven Forums iOS App Seven Forums Android App