Results 1 to 3 of 3
  1. #1

    Automatic chart ranges (2000 SR1)

    Please forgive me if this question has been asked and answered a million times. I don't use Excel very much, and I haven't found the answer to this.

    I am charting seven data series. Each month a new row is added, containing a new data point for each of the series. in other words, in July I might be charting A6..A12, B6..B12, etc.; in August these change to A6..A13, B6..B13, etc.

    How can I set things up so that either (a) the chart ranges are updated automatically, or ([img]/forums/images/smilies/cool.gif[/img] I can update all seven ranges quickly, say by changing a single cell value?


  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Adelaide, South Australia, Australia
    Thanked 0 Times in 0 Posts

    Re: Automatic chart ranges (2000 SR1)

    Since you update infrequently your easiest solution is to drag the cells containing your newly entered data onto the chart which will automatically update incorporating them.
    Here are a couple of references that should help if you want something more elaborate.

    <A target="_blank" HREF=>Dynamic Named Ranges</A>
    <A target="_blank" HREF=>Charting Dynamic Data</A>

    Apologies to those who have seen these before but the lounge Search is playing up.

  3. #3

    Re: Automatic chart ranges (2000 SR1)

    Hey, the dynamic named ranges thing actually works. Thanks so much.

Posting Permissions

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