Bubble Charts

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

K. Georgiadis

I have a bubble chart that plots 7 business opportunities
as follows:
a) Attractivenes on the Y axis (10 lowest, 100 highest)
b) Probability of success as a % on the X axis(10 lowest,
100 highest)
c) the magnitude of the potential profit contribution
reflected in the size of the bubbles.

Questions:

I. When I set the Y axis scale manually, with a maximum
value of 100, the bubbles on top of the chart
get "squashed.' If I allow automatic settings, the scale
is set to 150 or higher, which does not conform with the
rating convention. How can I overcome this?

II. Is there any way for the X scale (% probability of
success) to go from highest to lowest, i.e. 100 to 10,
instead of the conventional 10 to 100?
 
Yasou -

In XL XP, I just made a bubble chart such as you describe. The bubbles
that extend beyond the edge of the plot area are cut off, not really
squashed. What I would do is let the axes go beyond 100, and use a
custom number format to hide the values >100. The axis extends beyond
this, as will the axis ticks. Double click the axis, click on the number
tab, select Custom from the list on the left, and enter this in the box:

[>100]" ";0

Any of the funny tricks I usually like to use to make charts behave for
me won't work, because bubble charts don't allow combination with other
types.

For your second question, double click the axis, click on the scale tab,
and check the Values in Reverse Order checkbox (and probably also the Y
Axis Crosses at Maximum box).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Efharisto poli!
-----Original Message-----
Yasou -

In XL XP, I just made a bubble chart such as you describe. The bubbles
that extend beyond the edge of the plot area are cut off, not really
squashed. What I would do is let the axes go beyond 100, and use a
custom number format to hide the values >100. The axis extends beyond
this, as will the axis ticks. Double click the axis, click on the number
tab, select Custom from the list on the left, and enter this in the box:

[>100]" ";0

Any of the funny tricks I usually like to use to make charts behave for
me won't work, because bubble charts don't allow combination with other
types.

For your second question, double click the axis, click on the scale tab,
and check the Values in Reverse Order checkbox (and probably also the Y
Axis Crosses at Maximum box).

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

K. Georgiadis said:
I have a bubble chart that plots 7 business opportunities
as follows:
a) Attractivenes on the Y axis (10 lowest, 100 highest)
b) Probability of success as a % on the X axis(10 lowest,
100 highest)
c) the magnitude of the potential profit contribution
reflected in the size of the bubbles.

Questions:

I. When I set the Y axis scale manually, with a maximum
value of 100, the bubbles on top of the chart
get "squashed.' If I allow automatic settings, the scale
is set to 150 or higher, which does not conform with the
rating convention. How can I overcome this?

II. Is there any way for the X scale (% probability of
success) to go from highest to lowest, i.e. 100 to 10,
instead of the conventional 10 to 100?
Click to expand...

.
Click to expand...
 
Your recommendations worked perfectly. Thanks!
Let me take this opportunity to add that you have a
great, most useful website.
-----Original Message-----
Yasou -

In XL XP, I just made a bubble chart such as you describe. The bubbles
that extend beyond the edge of the plot area are cut off, not really
squashed. What I would do is let the axes go beyond 100, and use a
custom number format to hide the values >100. The axis extends beyond
this, as will the axis ticks. Double click the axis, click on the number
tab, select Custom from the list on the left, and enter this in the box:

[>100]" ";0

Any of the funny tricks I usually like to use to make charts behave for
me won't work, because bubble charts don't allow combination with other
types.

For your second question, double click the axis, click on the scale tab,
and check the Values in Reverse Order checkbox (and probably also the Y
Axis Crosses at Maximum box).

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

K. Georgiadis said:
I have a bubble chart that plots 7 business opportunities
as follows:
a) Attractivenes on the Y axis (10 lowest, 100 highest)
b) Probability of success as a % on the X axis(10 lowest,
100 highest)
c) the magnitude of the potential profit contribution
reflected in the size of the bubbles.

Questions:

I. When I set the Y axis scale manually, with a maximum
value of 100, the bubbles on top of the chart
get "squashed.' If I allow automatic settings, the scale
is set to 150 or higher, which does not conform with the
rating convention. How can I overcome this?

II. Is there any way for the X scale (% probability of
success) to go from highest to lowest, i.e. 100 to 10,
instead of the conventional 10 to 100?
Click to expand...

.
Click to expand...
 
My turn to say thanks.

- Jon

K. Georgiadis said:
Your recommendations worked perfectly. Thanks!
Let me take this opportunity to add that you have a
great, most useful website.
-----Original Message-----
Yasou -

In XL XP, I just made a bubble chart such as you
Click to expand...

describe. The bubbles
that extend beyond the edge of the plot area are cut
Click to expand...

off, not really
squashed. What I would do is let the axes go beyond 100,
Click to expand...

and use a
custom number format to hide the values >100. The axis
Click to expand...

extends beyond
this, as will the axis ticks. Double click the axis,
Click to expand...

click on the number
tab, select Custom from the list on the left, and enter
Click to expand...

this in the box:
[>100]" ";0

Any of the funny tricks I usually like to use to make
Click to expand...

charts behave for
me won't work, because bubble charts don't allow
Click to expand...

combination with other
types.

For your second question, double click the axis, click
Click to expand...

on the scale tab,
and check the Values in Reverse Order checkbox (and
Click to expand...

probably also the Y
Axis Crosses at Maximum box).

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

K. Georgiadis wrote:


opportunities

lowest,

maximum

scale

the


.
Click to expand...
Click to expand...
 
Back
Top