(1) See this page for a workaround:

http://peltiertech.com/Excel/Charts/...bbleSizes.html

(2) There is no way built into Excel to make this kind of legend. You would
have to carefully draw a bunch of circles and use text boxes for labels.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"keesberbee" <keesberbee.2a7l8o_1151660407.5559@excelforum-nospam.com> wrote
in message news:keesberbee.2a7l8o_1151660407.5559@excelforum-nospam.com...
>
> Lately I am working with Bubble Charts and I noticed two problems that I
> cannot solve.
>
> (1) Comparing multiple Bubble Charts that have dissimilar bubble size
> data is not possible. The problem is that if you use the same size
> multiplier, the bubbles in each chart have the same size, despite the
> difference in bubble size values. For example the bubble sizes of the
> next 2 tables are similar:
> X1: 2, 3, 4, 5; Y1: 4, 3, 2, 1; Bubble1: 4, 3, 2, 1
> X2: 2, 3, 4, 5; Y2: 4, 3, 2, 1; Bubble2: 0.4, 0.3, 0.2, 0.1
> Of course there are some ways to overcome this problem, but they cause
> a lot extra work or are not dynamic. I am looking for a Macro or VBA
> procedure that generates bubble sizes in multiple charts that are sized
> according to the same bubble size scale.
>
> (2) I also noticed that Bubble Charts in Excel don't have a proper
> legend: they only inform about the third dimension (e.g. revenues). I
> am looking for a legend that informs the user about the bubble sizes
> and their values or ranges. A fourth dimensions can even be included in
> the charts: 'colour of the bubbles'. Also for this matter I would like
> to have a clear legend. My question: is there any macro or VBA
> procedure for the bubble legend?
> Hopefully, someone can help me: you will help me a lot!
>
>
> --
> keesberbee
> ------------------------------------------------------------------------
> keesberbee's Profile:
> http://www.excelforum.com/member.php...o&userid=35899
> View this thread: http://www.excelforum.com/showthread...hreadid=557235
>