Chart Legend Renaming

Annie_B

Can you edit the legend titles? I created a chart widget but the legend has the title for the column that the metrics are in (I currently have the metrics on locked rows inserted above the info on the sheet)

Kayci

Hello Annie_b

I think you can if you unlock and go into the sheet to edit the names of the columns that there that you would like to see changes in the chart view, and then re-lock the sheet. The changes should be reflected in your chart titles.

-Kayci

Annie_B

thank you Kayci, the only problem is that the columns I have the metrics in are used for the sheet and can't be changed.  I just learned of a way to move the metrics onto a separate sheet but can't figure out the formulas to move these since it has so many columns to pull.