How to update chart automatically as new data added?
Thanks,
hmgrts
How to update chart automatically as new data added?
Thanks,
hmgrts
Last edited by hmgrts; 06-30-2009 at 12:15 AM.
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks