Chart source

[gbarclay2001]

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

 

[Aladin Akyurek]

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/viewtopic.php?topic=7435&forum=2

to see whether that would help.

Aladin

 

[gbarclay2001]

Looks complicated! I'll try it later, thanks