Automatic axis settings for bubble chart via VBA

Hi,

I am searching for a possibility for an automatic setting
of the minimum axis values in a bubble chart via VBA.
Normally, the automatic axis setting could do the job,
but if the difference between the values on one axis are
greater than 20%, the automatic routine sets the min axis
value to 0.

Is there a possibility to create a VBA function, which is
able to the job for values which habe a difference of
more than 20%?

Thanks in advance!

Dirk Grunewald

Dirk Grunewald wrote:
I am searching for a possibility for an automatic setting
of the minimum axis values in a bubble chart via VBA.

Tushar has one potential answer. It's not VBA - his add-in uses the
contents of a cell to set the min and max. Go to www.tushar-mehta.com and
find the AutoChart Manager on the left side of the screen.

Here are a few posts that show how to write your own axis-scaling routines.

http://groups.google.com/groups?selm...GP10.phx.gb l
http://groups.google.com/groups?selm...%40tkmsftngp11
http://groups.google.com/groups?selm...07%40yahoo.com
http://groups.google.com/groups?selm...523%40home.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

dvt wrote:
Dirk Grunewald wrote:

I am searching for a possibility for an automatic setting
of the minimum axis values in a bubble chart via VBA.


Tushar has one potential answer. It's not VBA - his add-in uses the
contents of a cell to set the min and max. Go to www.tushar-mehta.com and
find the AutoChart Manager on the left side of the screen.

Hi Jon,

I can't use these axis-scaling routines, because I habve
to handle the axis settings for a bubble chart not not a
normal x-y-diagram.

This is due to the fact, that you can't use e.g. the min
value of your data point as the scaling parameter,
because there is the bubble around this data point.
If you want to show the whole bubble, then you have to
use a min value min value of your datapoint.

Moreover, the the necessary min value depends of the
whole axis scaling, because there is a resizing function
for the bubbles.

Dirk
-----Original Message-----
Here are a few posts that show how to write your own
axis-scaling routines.

http://groups.google.com/groups?selm=OIIpQwW2CHA.1636%
40TK2MSFTNGP10.phx.gbl
http://groups.google.com/groups?selm=etUr0zUdCHA.1864%
40tkmsftngp11
http://groups.google.com/groups?selm=3F0AF6F9.6080107%
40yahoo.com
http://groups.google.com/groups?selm=3A8C8FA6.D2527523%
40home.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

dvt wrote:
Dirk Grunewald wrote:

I am searching for a possibility for an automatic
setting
of the minimum axis values in a bubble chart via VBA.


Tushar has one potential answer. It's not VBA - his
add-in uses the
contents of a cell to set the min and max. Go to
www.tushar-mehta.com and
find the AutoChart Manager on the left side of the
screen.



.

Dirk -

This is when you have to do a little trial and error. You can get the
relative bubble sizes, you can get the multiple of the default size that
is used, and then you have to play a bit to find what the default size
is. Then step through the points, and find which point's bubble extends
highest, lowest, etc. More work, but still within the realm of what's
possible.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Dirk Grunewald wrote:
Hi Jon,

I can't use these axis-scaling routines, because I habve
to handle the axis settings for a bubble chart not not a
normal x-y-diagram.

This is due to the fact, that you can't use e.g. the min
value of your data point as the scaling parameter,
because there is the bubble around this data point.
If you want to show the whole bubble, then you have to
use a min value min value of your datapoint.

Moreover, the the necessary min value depends of the
whole axis scaling, because there is a resizing function
for the bubbles.

Dirk

-----Original Message-----
Here are a few posts that show how to write your own

axis-scaling routines.

http://groups.google.com/groups?selm=OIIpQwW2CHA.1636%

40TK2MSFTNGP10.phx.gbl

http://groups.google.com/groups?selm=etUr0zUdCHA.1864%

40tkmsftngp11

http://groups.google.com/groups?selm=3F0AF6F9.6080107%

40yahoo.com

http://groups.google.com/groups?selm=3A8C8FA6.D2527523%

40home.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

dvt wrote:

Dirk Grunewald wrote:


I am searching for a possibility for an automatic

setting

of the minimum axis values in a bubble chart via VBA.


Tushar has one potential answer. It's not VBA - his

add-in uses the

contents of a cell to set the min and max. Go to

www.tushar-mehta.com and

find the AutoChart Manager on the left side of the

screen.


.