Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Location
    Thousand Oaks, California, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Trying to automatically update chart range (2000)

    <P ID="edit" class=small>(Edited by WebGenii on 28-Apr-03 17:05. to add link)</P>I have a very large worksheet to which I am frequently adding data which is then plotted on several charts using only the most recent data. I was trying to use the method from Microsoft Knowledge Base Article <!mskb=183446>Microsoft Knowledge Base Article 183446<!/mskb> (using defined names) to accomplish the task but I cannot even get their basic example to work. Has anyone had any luck in using that Article? Or do you have any idea how the problem might be approached?

    Thanks,

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Perth, Western Australia, Australia
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trying to automatically update chart range (2000)

    I am certainly no expert but I think J-Walk may help.

  3. #3
    New Lounger
    Join Date
    Apr 2003
    Location
    Thousand Oaks, California, USA
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Trying to automatically update chart range (2000)

    Thanks Kieran, that did work. Now I have to check my previous work as that is nearly exactly what I did before.

Posting Permissions

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