Hi
I have a dynamic bubble chart with market share on the x axis and % mkt shr growth on the y axis.
I need to be able to to establish what the max value is on either scale so i can use a formula to calculate where to position an autoshape which indicates the average.
The formula is all worked out, I am just stuck on how I can get the value of the max scale of either axis as the scale changes every time I select a new set of data to look at.
Thanks in anticipation
Boxer
I have a dynamic bubble chart with market share on the x axis and % mkt shr growth on the y axis.
I need to be able to to establish what the max value is on either scale so i can use a formula to calculate where to position an autoshape which indicates the average.
The formula is all worked out, I am just stuck on how I can get the value of the max scale of either axis as the scale changes every time I select a new set of data to look at.
Thanks in anticipation
Boxer