Hi.

I'm creating an sheet which has the records of the invoices done in our firm this year. Thats done and working. Now i started working on making a table that lists the total amount associated with each of our clients.

For example we've done 40 invoices so far this year, but with only 11 unique customers. I've set up a system that lists the number of unique names in a cell, and then write the names and money invoiced for next to it.

its based on the formula used in this video: http://www.youtube.com/watch?v=0KnwjhjdbwY

All that is working just fine, my problem is now that i want to create some charts to display the data. And if i selected the entire column, the chart looks stupid due to the large amount of empty cells. I then tried converting it to a table, which works fine. But when i add new names to the list, i need the table listing unique names to increase.

So i need a way to set the size of a table dynamicly.. I was hoping to be able to do this without coding, but it seems i will have to?

Any help is greatly appriciated