Hi,

I have a spreadsheet with about 15 charts. I want to be able to
automatically switch between charts in the "Main" tab based on an input. So
for example if I input "1" chart #1 would appear in the "Main" tab. All of
the charts are different (they have different units for the X and Y values)
so I cannot use a named range (at least I don't know how to use the named
range).

Thanks