Changing Chart with a lookup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top