How to update chart automatically as new data added?

I am not able to donwload your .xlsm file in my version 2002 of excel

suppose there is data A1 to A5 in sheet1

click insert(menu)-name-define
in the name give some name e.g. sheet1!rv
in the reference type this formula

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
(there should not be any other data in column A if there are like column
headings in A1 and data from A2 to A6 then the reference will be


=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A:$A)-1,1)

now in the chart wizard step 2 click series
click add (at the bottom) in the values type
=sheeet1!rv

and then click finish.

if you add or delete entries in columnA the chart will be automatically changed

to understand more refer to this webpage

http://peltiertech.com/Excel/Charts/...umnChart1.html

Thank you!

deleted deleted

Originally Posted by hmgrts

How to update chart automatically as new data added?

Thanks,
hmgrts

hmgrts,
I am very impressed with what you have done. I am wondering if you can check out my post:

http://www.excelforum.com/excel-char...ntire-pie.html

I would appreciated hearing from you any ideas you may have to show multiple pie slices that are common as one single combined pie slice that is proportional to the entire pie. Any info you can provide will be greatly appreciated. Thanks