Auto updated chart

**taleksak** · 10-01-2007, 01:57 PM

Hi

I am trying to have and auto updated chart. I want to add a new date (in row A) and a new value (in row B) every time I open my excel file. But I don't want to have and ex. =(K22) in the cell that goes to the chart. This will influence the chart before the data has been added.

What I want is a kind of "send value to" function. So that the cell which send info to the chart is empty untill it is auto-updated.

Something like cell K22 has the following function (=Send"23.10.2007";(A23))
In this case cell A23 will be empty until this function is activated through an =if function activates cell K22

-Trygve

**oldchippy** · 10-01-2007, 05:24 PM

Does this link offer any help?

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

**taleksak** · 10-03-2007, 05:21 PM

Thanks but this didn't help.

My problem is to make cell A send an input to cell B, so that cell B can stay empty untill it is needed in the chart.

**oldchippy** · 10-04-2007, 06:23 AM

Do you mean something like this?

=IF(K22=VALUE("23/10/2007"),A23,"")

**taleksak** · 10-04-2007, 08:28 AM

No sorry, not that either...

I know it is the wrong fx, but just to illustrate:
=IF(K22=VALUE("23/10/2007");A23;(""))
My goal is to make A23 say "23/10/2007" when K22's value is "23/10/2007", but without writing any fx into A23. Cell A23 should stay totaly empty until the 23/10/2007

thanks so far :-)

**oldchippy** · 10-05-2007, 05:23 AM

OK, so you want A23 to remain blank until 23/10/2007?

How about this in A23

=IF(K22=TODAY(),K22,"") then when A23 gets to 23/10/2007, then it will display in A23, before or after that date it displays blank

or if you want A23 to display even after 23/10/2007, then you could use this

=IF(K22<=TODAY(),K22,"")

**taleksak** · 10-05-2007, 05:51 AM

I want A23 to be totaly empty.. nothing.. not even a fx (function) that is hidden. K22 should be the cell that makes something happen in cell A23

-Taleksak

**oldchippy** · 10-05-2007, 05:54 AM

I would say the only way to do this is with VBA, unfortunately, not my expertise, but may be one of the programmers can help? - ANY ONE OUT THERE?

**VBA Noob** · 10-05-2007, 06:09 AM

See if this works.

Right click the sheet tab > select view code > paste the below in.

Type 23/10/07 into any cell in Col A and Col B will return that date

Please Login or Register  to view this content.

VBA Noob

**taleksak** · 10-07-2007, 05:45 AM

I couldn't make the visual basic code work, but I have a good feeling about VB. But my skills are not good enough... I think I might need to read a few books :-)

Thanks to both of you