View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Steen Steen is offline
external usenet poster
 
Posts: 104
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