No, there is no way to get it to read the tab name and use that as the label. It is best to include the label similar to what Prashanth KV showed, you could do that on each sheet though if your ranges are from different sheets. Or else you could create a summary table on one tab that includes the header/label and the data at the same time.

John Schnupp

Feb 14, 2020

Well this is totally frustrating...at least Microsoft had the ability to add text to the legend. The data that I am charting is in the middle of a big spreadsheet, there is no top row or first column that I can designate for the legend. Google might be good for a lot of stuff it aint Microsoft that's for sure.

Brendan Dillon

Feb 21, 2020

I'll second John. This answer and approach is wholly unsatisfactory. What a load.

KarlS

Diamond Product Expert

Forum volunteer, not Google employee

Feb 21, 2020

Everyone in this forum, unless their profile specifically says "Google Employee", is a volunteer, even the Product Experts. As such, we do not have access to internal Google data or systems and are unable to directly help in some types of problems. We try to provide solutions or work-arounds within those limits but are not always able to get something that works for your situation. In those cases, I would encourage you to send a feature request to the developers using the in-product feedback tools (instructions below). Feedback submitted there will go directly to the development team and the more people who request a feature like this the more likely it will be implemented.

For Docs/Sheets/Slides: You can send feedback from the Help menu > Report an issue. (For some this will be "Help Sheets/Docs/Slides improve" instead.)
For Mobile: To submit feedback from the mobile app, touch the menu in the top-left of the app (top-right in a file), touch Help & Feedback, and then choose Send Feedback to write and submit your report.