Hello all,

First, I did look around the sight for about an hour looking at different posts, but I couldn't quite find what I am looking for. I have a spreadsheet that has multiple charts on it. Ideally I would like to have a separate sheet that would display one of the charts that is depending on what is displayed in 1 particular cell from a drop down menu list. I have the drop down list created, I am just unsure of how to write either the VB behind to display the chart that I want or to write an IF statement. PLEASE HELP! Thanks!