Auto Range Selection of Column Chart by Macro

Ahem, maybe you should read the help notes for the application that you are using. In Mathcad auto-ranging is a simple function.

Websites below define how to make an automatic chart that resizes without a macro to match the size of the square of data.

You will need to use a named range and offset commands.

http://www.techrepublic.com/article/create-an-excel-chart-that-automatically-updates-with-new-data/6064314

http://spreadsheetpage.com/index.php/tip/update_charts_automatically_when_you_enter_new_data/

http://office.microsoft.com/en-us/excel-help/using-named-ranges-to-create-dynamic-charts-in-excel-HA001109801.aspx

Or you can use the result from offset command to define the square for the graph. You can use the result of that cell inside your macro to create a chart.

Thanks Smitch!

You have solved my major problem...

Very useful & perfect reply you have given.