If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Legend Bubble Chart
Can anybody help me?
I want to create a bubble chart where 3 values are plotted for each product (e.g. profit, sales, distribution). I want each bubble to correspond to a product and to be a different color. The legend should show which bubble corresponds to which product. How do I do this? Thanks in advance! |
#2
|
|||
|
|||
Legend Bubble Chart
Make your bobble chart with all the same colors. Double click on the
series, and on the Options tab, check the Vary Colors By Point box. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Pep wrote: Can anybody help me? I want to create a bubble chart where 3 values are plotted for each product (e.g. profit, sales, distribution). I want each bubble to correspond to a product and to be a different color. The legend should show which bubble corresponds to which product. How do I do this? Thanks in advance! |
Thread Tools | |
Display Modes | |
|
|