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).
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
Yes. On that same tab there is a selection for Data Select Ranges
On the popup, choose your HEADER row first. This is important. Then click on add another range.
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.