Hello everybody

I have the following question for U:

I have a table with lots of values in rows and lines.
Imagine a matrix with 10 rows and 10 lines that represent customers and
products sold to them. The values in this table represent the earnings,
like:

12,59 1,94 345,46
16,97 136,48 -256,87
1,92 356,9 -658,9...

As you see there are also negative values.
Now I want to have bubbles that represent these values.
Red ones for the negative values and green ones for the positives.

Does any body have an idea what I could do?
I tried the bubble chart but as you know it just works with x,y,and
bubblesize values and not more.
I don´t want to reorganize the table and just a macro that could be
applied to the values.

I thankk you for your help in advance

greets
haydar


--
Haydar
------------------------------------------------------------------------
Haydar's Profile: http://www.excelforum.com/member.php...o&userid=26041
View this thread: http://www.excelforum.com/showthread...hreadid=393877