David,

Thanks for your replay. Setting the values is the easier part. I was
having a hard time extracting the source information to then know what the
min and max are currently within the series. I was able to get this, now all
I have to do is figure out what the buffer should be between the series
max/min and the chart max/min so that the charts look clean.

Thanks again.
jbl

"JbL" wrote:

Hi,

I am trying to write a code that will programitically alter a charts scaling
(right now assuming only 1 data series per chart) for the min, max, major
unit, etc that is based on the values in the chart. I have been able to
change these specs based on values I provide by looking at the chart, but I
am hoping to create a code that I will basically be able to make the min
scale X% below the lowest value in the chart series, the max X% above the
highest value and the units some portion of the range inbetween.

I'm using a dynamic chart with a named range. Do I need to have the code
extract that name from the chart series and then look though those cells in
data series? Or is there a simple way to pull that info from the chart
itself?

Thank you for any assistance.

Regards,
jbl