How to create Dynamic Charts on Spilled Range

Hello All,

Wish you a Very Happy 2022!

I was searching for creating Dynamic charts and came across your video on YouTube - https://www.youtube.com/watch?v=1t4NVRlH_d4 This video explains about creating charts based on dynamic table range.

However, I am looking for creating charts on Dynamic Spilled Range. More specifically, I am using STOCKHISTORY function and have created a simple macro to display the historical prices in desired Daily, Weekly or Monthly range. 4th parameter in below line gets changes based on users preference. Range("B7").Formula2 = "=STOCKHISTORY(A2,B2,B3,0,1,0,1,2,3,4,5)" Basis the users choice, the data is populated by the STOCKHISTORY function dynamically.

I am looking for the chart to dynamically get updated. Y-axis does get auto-updated, however, the X-axis remains static.  Look forward for your guidance!

Cheers,

Divyesh