Details may vary depending on your your version of the p[rogram -- please
always state that -- but the basic answers are:
Go ahead & select the data to be plotted & create a chart, then select the
data for the next chart & do the same... Just be sure that no existing
charts are selected when you create another. The new chart may directly
overlay the previous one so just drag it to a different location on the
sheet.
Charts on sheets are graphic objects so you can't put them in a "drop down".
You may be able to accomplish the effect by hyperlinking to the charts but
my preference [FWIW] is to create Custom Views & add the Custom Views combo
box to a toolbar. With no additional detail, however, it's hard to offer any
other suggestions.
