ActiveSheet.ChartObjects in one line

**aaa4948** · 07-08-2013, 02:49 PM

I have the following code to set the minimum value of the y-axis of "My Graph":

Please Login or Register  to view this content.

Is there a way that I can do this in one line? For example:

Please Login or Register  to view this content.

I'm trying to figure out how to point to anything anywhere. Could I even lose the ActiveSheet part? Is there something like this?:

Please Login or Register  to view this content.

I'm hoping to be able to point at anything anywhere.

Thanks for the help!

**Norie** · 07-08-2013, 03:05 PM

You can't do something like that in one line.

As for replacing ActiveSheet with a reference to a specific named sheet, that shouldn't be a problem.

**Andy Pope** · 07-09-2013, 03:30 AM

Why not?

Please Login or Register  to view this content.

And for the currently selected chart

Please Login or Register  to view this content.

**Norie** · 07-09-2013, 05:33 AM

Oops, for some reason I thought the OP wanted to set the MinimumScale for multiple charts with one line.7

No idea why.

Re: ActiveSheet.ChartObjects in one line