Chart Legend Renaming

Options
Annie_B
Annie_B
edited 12/09/19 in Smartsheet Basics

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)

SSHEET.PNG

Comments

  • Kayci
    Options

    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
    Options

    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.