Results 1 to 11 of 11

Auto updated chart

Threaded View

  1. #1
    Registered User
    Join Date
    10-01-2007
    Posts
    7

    Auto updated chart

    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
    Last edited by VBA Noob; 10-01-2007 at 02:26 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1