I have one sheet of data that refers to multiple other sheets of data. From that one sheet I am creating charts with drop down lists to select the cases the individual wants to use. I have 3 different charts that I need to make and I would like to put them on the same sheet, so as not to confuse the vlookup with different drop downs. I would like to make one chart visible at a time, using a button (or some other tool) to change the chart being displayed.