Dynamic charts - horizontal data

[Lund]

Hi,

Is it possible to do dynamic charting when the data set is horizontal (in rows)? All the great sites with examples from Google are all shown with column data.

Normally I just transpose the data set, but I'm not the only one who puts in new data, so it would be alot of help if it's possible to do the offset function in rows?

Thanks,

 

[wolverineb]

The OFFSET function works equally well horizontally.

Instead of something like this:
=OFFSET($G$1,0,0,COUNTA($G:$G)-1)

You just have something like this:
=OFFSET($A$7,0,0,1,COUNTA($7:$7)-1)

(Mind the positions of your arguments. The width is in a different place than the height.)