View Single Post
  #1  
Old September 27th, 2009, 08:21 PM posted to microsoft.public.excel.charting
Steen
external usenet poster
 
Posts: 59
Default Bubble Chart - x, y, size, name, type

Hi all

I would like to make a bubble chart that will automatic update when data is
changed. The chart data consist of the following type of data in general;

Name
(Label) Ease (x) Risk (y) Size (cost) Type (colour)
Product A 1 2 1 New Product (Red)
Product B 2 3 2 New Product (Red)
Product C 3 1 6 Improvement (Green)
Product D 4 5 3 Improvement (Green)
Product E 5 1 2 Cost Out (Gray)
… … … … …

The colour should be transparent if possible. It would also be nice if the
bubble graph would automatic update if a new product is inserted / deleted.

/Steen