How to edit legend labels in google spreadsheet plots?

Foad picture Foad · Dec 21, 2017 · Viewed 49.6k times · Source

I'm trying to plot some data in Google spreadsheet:

enter image description here

And as you may see all of the series are in a same column and I can't use the any of the rows as headers. My plot looks like this:

enter image description here

I would appreciate if you could help me know how I can edit/add legend labels.

Answer

metoyou picture metoyou · May 17, 2018

Unfortunately I don't think the graphs were intended for your data format.

The only way I've been able to work out how to add a header is by reformatting my data so I have the header at the top of my ranges.

So I suggest you split your data into separate columns so you have;

D2:D4, E2:E4, F2:F4 etc with D1, E1, and F1 as your header and then selecting "Use row 1 as your headers." From the data menu.

Alternatively, you could add labels to the series themselves. Although not ideal, it could be quicker than reformatting your data. On the data menu, click on the three dots of a data series to bring up a menu that allows you to add a label. Unfortunately this needs to be a cell so you'll have to have that header on your sheet some where.