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).
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.