I have an excel sheet in which I have the data for a few stocks. I have created a line chart to easily visualize this price information.
I am looking for some simple method by which I can QUICKLY Change the data series that is being shown in the price chart, with just one mouse click. So that I can quickly visualize 10 different stock charts, one by one, in the same chart window, instead of having the need to create 10 different charts for the same.
Please suggest various methods by which this could be done.
If you have any doubts, then please ask them, and I would explain in more details.
I am using the following software versions -
Microsoft SQL Server Management Studio version- 12.0.2000.8,
Microsoft Office 2016 x64
and Windows 7 x64
I have attached the Excel File having the data and the sample chart.