Help with setting chart axes and ranges

The is not a chart collection within the activesheet object.

There is for a workbook object. These are the chart sheet type.

If you have chart objects then use the chartobjects collection of the worksheet

Please Login or Register  to view this content.

What chart type do you have?

It fails because the default horizontal axis on an area chart is a categorical one and not numeric.
If you really meant for the horizontal axis to be numeric you will need to trick it by setting the axis to be Date type rather than text. Then the code would work.

Probably better to use numeric values rather than text.

Please Login or Register  to view this content.

In many kinds of chart you can't change the minimum and maximum axis scale

what is your actual intention of this code?

as you are using an AREA chart type
to change the X-AXIS i believe you need to change the actual data series rather than just the scale

here's my crack at doing that

i suppose you don't need select case
its in there if you want to extrapolate if/when you have varied chart types

probably needs some error traps as well but ...anyways you get the idea