I have a chart in a spreadsheet. If I click on it and select 'advanced edit' > Start, it offers to 'Use row 12 as headers'. How can I use a different row for the header names? My data has rows for the headers, some rows of old data I dont want displayed, the data (which starts at row 12).

closed as off-topic by pnuts, jonsca Nov 11 '17 at 22:05

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions on applications or application features that are no longer available are off-topic for Web Applications as no one will ever be able to make use of the answers again." – pnuts, jonsca
If this question can be reworded to fit the rules in the help center, please edit the question.


Yes. On that same tab there is a selection for Data Select Ranges

enter image description here

On the popup, choose your HEADER row first. This is important. Then click on add another range. enter image description here

Now choose your data. Click Ok

Under "combine ranges" choose vertically.

Make sure the box is checked that says "use row XX as a header". (this would be the first range you chose).

I think that is what you are looking for.

  • @William: It only works if you put your header row first in the textbox, so you may have to change Results!K77:P77, Results!K1:P1 to Results!K1:P1, Results!K77:P77. – Gruber Jun 18 '14 at 7:14

Not the answer you're looking for? Browse other questions tagged or ask your own question.