Update charts with Dynamic range

Hello Friendz,

I have a Sheet Named "main" which have data from (B3- E6) as same is source for 2 charts in other sheet.

Now the Columns & Row will be increased how can we have the Button click update the range in source data..
so that the charts gets refreshed with the current range...

Can we have a VBA code which will update the charts in accordance to the data range in sheet "Main"
no matter how many columns are there or how many rows are there Please assist.

Pleases see the attached file

Will it not update if you use a named range for your defined range?

The columns & rows will be more ... I don't know how to do that

There's a pertinent tutorial here: http://www.techrepublic.com/blog/mic...arts-in-excel/

You can create main sheet as table.

Select the whole data in main sheet and press control+T it will make your data in table format and whenever you will insert data in that able chat will autoupdate.

Hope this will help you