How to make a dropdown list such that... (see details)
- by daysandtimes
I want to plot the stock prices of certain companies VS the S&P500. I have all the price data downloaded in my excel sheet already.
I want to create a line graph in Excel. One line is fixed and that would be the S&P500, and the other would be the company I select. I know how to use data validation to create a dropdown list, but how could I…