Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Chart source

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi all,

    I'm trying to use the offset command to make the source of a chart change when data is entered. Data is filled in each month so for now I want the graph to show Jan - May, but when June's data is typed into the related table I want the chart to extend it's range to show Jan - June. Make sense?

    Anyway I'm getting nowhere. I have the offset formula in a cell at the moment (I've not put it into the graph source) but it just comes up with 0 no matter what I type in the range. Anyone know what I'm doing wrong?


    =OFFSET(Sheet1!$A$29,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$33:$33))

    Thanks for any help,

    Greg

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,637
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-10 05:44, gbarclay2001 wrote:
    Hi all,

    I'm trying to use the offset command to make the source of a chart change when data is entered. Data is filled in each month so for now I want the graph to show Jan - May, but when June's data is typed into the related table I want the chart to extend it's range to show Jan - June. Make sense?

    Anyway I'm getting nowhere. I have the offset formula in a cell at the moment (I've not put it into the graph source) but it just comes up with 0 no matter what I type in the range. Anyone know what I'm doing wrong?


    =OFFSET(Sheet1!$A$29,COUNTA(Sheet1!$A:$A),COUNTA(Sheet1!$33:$33))

    Thanks for any help,

    Greg
    What you're after is a "dynamic chart". Have a look at my contribs in the thread:

    http://www.mrexcel.com/board/viewtop...c=7435&forum=2

    to see whether that would help.

    Aladin

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    London
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Looks complicated! I'll try it later, thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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