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
Bookmarks