Graph of a varying size

[mannsi]

Hello,
Sorry if this question has been posted before. I couldn't find it.
I'm making an Excel graph based on a Sql query I run and shows in a different worksheet. My problem is that I get different amount of result each time the query is run but my graph is always of a fixed size. If I set the data range of the graph as something huge I get a bad looking graph.
How can I edit the graph so that it has a big data-range but only shows cells with data in them ?

 

[Andrew Poulsom]

Look here:

http://peltiertech.com/Excel/Charts/Dynamics.html#DynColCht

 

[mannsi]

Thank you for that link.

I seem to have some wierd problem though. I went through the directions in the link but I now I get errors with a formula of mine. I press Ctrl + F3 and chose my "Names in workbook" to be 'Query!Values' (Query being the target worksheet) and in the "refers to" I put the same value as done in the instructions (after modifying my query to return results of the same format as in the instructions) :

=OFFSET(Query!$B$1,1,0,COUNTA(Query!$B:$B)-1,1)

But I keep getting an error saying that the formula that I typed contains an error. I have tried to change the OFFSET parameters but even with

=OFFSET(Query!$B$1,0,0,1,1)

I still get the same error.
Any ideas ?

 

[Andrew Poulsom]

Is the comma or the semicolon your argument separator. If the latter:

=OFFSET(Query!$B$1;1;0;COUNTA(Query!$B:$B)-1;1)

 

[mannsi]

Worked like a charm. Thanks