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