Help with plotting new chart after every data refresh

[ebutu555]

Hi All,

I'm extracting live data (Index Options)from website and have set the refresh frequency as 5 minutes. So, the data is getting updated every 5 minutes and I've created a clustered column chart to monitor columns OI, Change in OI and Volume for both Calls/Puts section. Now, instead of seeing the data update in the same chart after data refresh, I want a new clustered column chart to be created after every data refresh. So, for the refresh rate of 5 minutes, 72 charts should be created for the market period of 6 hours. This would allow to analyze the Calls/Puts build-up better. Also, for the column LTP (Last Traded Price), instead of column chart, I want to plot a line chart for different strike prices. For instance, I want to see the price updates for strike prices 8000, 8100, 8200, 9000, 9100, 9200 alone(both calls & puts section). I'm not sure how to achieve this. Any help would be very much appreciated.

Thanks.

Note: I've posted this query in other forums as well
https://www.excelforum.com/excel-pro...lp-please.html
https://www.excelguru.ca/forums/show...y-data-refresh


https://www.mrexcel.com/forum/excel-...a-refresh.html