Draw excel charts based on varying row range

[ajaysomasi]

Hi, I have data for which row range keeps changing based on input. How do I draw an excel chart to capture this varying nature of data range.. For instance, for some data, my row length may be 10, for another input, it may be 15 etc.. Any formula or VBA code is much appreciated.. All other aspects of the chart wont change, for instance bar chart or line chart aspects.. please help..

 

[sheetspread]

Dynamic named range