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!

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!