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
|
|||
|
|||
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 |
#2
|
|||
|
|||
Automatic axis settings for bubble chart via VBA
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. |
#3
|
|||
|
|||
Automatic axis settings for bubble chart via VBA
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. |
#4
|
|||
|
|||
Automatic axis settings for bubble chart via VBA
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. . |
#5
|
|||
|
|||
Automatic axis settings for bubble chart via VBA
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. . |
Thread Tools | |
Display Modes | |
|
|