06-28-2009, 09:31 PM
|
|
Registered User
|
|
Join Date: 17 Jun 2009
Location: Chennai,India
MS Office Version:Excel 2002
Posts: 76
|
|
|
Re: 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
|
How to update chart automatically as new data added?
Re: How to update chart automatically as new data added?
Linear Mode
