Hi, I'm looking to create a dynamic chart from a vlookup table because the vlookup can return a different number of rows and I only want to chart the data the vlookup returns. I have tried an offset formula but this does not work because even if there is no data in a cell, the vlookup formula is still in that cell and the chart recognises this as a zero value and the chart displays this.