I am trying to generate a pivot chart for some data which is linked to Team Foundation Server. I would like to specify a range of 2 columns in a sheet without reference to an end cell so that however many rows are retruned from the TFS server will be included in the chart. Normally I would do this by selecting the column headers. Since I have retrieved that data from TFS, I have a row at the top of my sheet that contains a header that I cannot select or hide.

How do indicate a rnage by column but allow for any filled rows, please?

Thanks.