HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?
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. |
HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?
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. |
HOW TO CREATE A BUBBLE CHART WITH CHANGING COLORS?
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 |
All times are GMT +1. The time now is 10:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com