I have an excel sheet in which I have the data for a few stocks and I need to create the Line Charts for them. But the Line Charts needs to be made in such a manner, that the “Number of Days to be plotted” do not need to be fixed beforehand. If I have 5 days data some day, then it should plot that 5 days data and if I have 20 days data on some other day, then it should automatically be able to plot those 20 days data, without any manual modifications from my side.
I have explained the requirement in very clear and detailed manner in the attached sample file.
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 charts.