PC Review


Reply
Thread Tools Rate Thread

HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?

 
 
=?Utf-8?B?SGVjdG9y?=
Guest
Posts: n/a
 
      14th May 2006
I WANT TO CREATE A BUBBLE CHART THAT COULD SHOW WHICH BUBBLE IS FROM WHICH
ROW OR COMPANY IN MY CASE. EACH BUBBLE COULD BE OF A DIFFERENT COLOR.
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SEVL?=
Guest
Posts: n/a
 
      14th May 2006
You need three parameters (X,Y, diam) for yr bubbles, which reprersent your
position (x,y) in the chart and the size of the bubble (diameter). The
bubble chart is standard with all bubbles of uniform colour. After you hv
created yr bubble chart, right-click the data series, choose Format Dat
Series/Options and tick "Vary colors by point", and all bubbles have a unique
colour. These can be changed individually if needed.
GL,
Henk

"Hector" wrote:

> I WANT TO CREATE A BUBBLE CHART THAT COULD SHOW WHICH BUBBLE IS FROM WHICH
> ROW OR COMPANY IN MY CASE. EACH BUBBLE COULD BE OF A DIFFERENT COLOR.

 
Reply With Quote
 
Andy Pope
Guest
Posts: n/a
 
      14th May 2006
Hi,

2 options. Create a series for each company or if you have a single
series enable the 'Vary color by points', which you can get at by double
clicking the series to bring up the format dialog and going to the
Series Option tab.

Cheers
Andy

Hector wrote:
> I WANT TO CREATE A BUBBLE CHART THAT COULD SHOW WHICH BUBBLE IS FROM WHICH
> ROW OR COMPANY IN MY CASE. EACH BUBBLE COULD BE OF A DIFFERENT COLOR.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create Multiple Series in a Bubble Chart? Kojones Microsoft Excel Charting 2 25th Jul 2008 01:52 PM
Excel 'bubble' chart where colors are used instead of bubble size =?Utf-8?B?cGF1bG1pY2hhZWw=?= Microsoft Excel Charting 2 19th Nov 2007 11:57 PM
Change shape of Bubble in Bubble Chart? And make them Transparent =?Utf-8?B?UGFvY28=?= Microsoft Powerpoint 1 9th Sep 2006 12:38 AM
ho to change in the bubble chart the bubble position and size =?Utf-8?B?bGFzemxv?= Microsoft Excel Charting 0 25th Mar 2005 04:45 PM
Changing Comment Bubble Colors =?Utf-8?B?QmVsaW5kYQ==?= Microsoft Word Document Management 2 3rd Feb 2005 03:51 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:09 PM.