How to edit legend in Excel

Other than utilizing worked in outline formats, you can physically add or alter singular graph marks, for example, the diagram title or hub titles.

Change the Chart Title

The graph title frequently shows up over the outline and is utilized to depict the information that is being introduced. You can add a totally new diagram title or just change the content of a current one.

  1. Select the chart.
  2. Right-click the chart title.
  3. Click the Edit Text button.
  4. Enter the new chart title.
  5. Click anywhere outside the title area.

Now Add Axis Title

The pivot titles portray for watchers the classification of information that is being spoken to. Without them, it very well may be hard to precisely depict data.

  1. Select the chart
  2. Click the Chart Elements button. Hover the mouse over the label options in the list to preview them on your chart before making your selection.
  3. Select the Axis Titles check box. A text box is added for both the vertical and horizontal axes.
  4. Enter descriptive axis titles.
  5. Click outside the title area.

Based On Your Searches You Might Be Interested In: office.com/setup

Position the Chart Legend

Normally when a diagram is made, a legend is added consequently. The legend distinguishes what data is depicted in the outline’s plot territory.

  1. Select the chart
  2. Click the Chart Elements button.
  3. Click the Legend button.Be careful not to click the word “Legend” or it will turn it off, just hover over it until the list arrow appears.
  4. Select a position for the legend.

Be mindful so as not to tap “Legend” or it will turn it off, simply drift over it until the rundown bolt shows up.


This is how you will edit legend in Excel once you are done with Office Setup. Also, learn about locking a cell in Excel. If you have any feedback for us, please feel free to use the comment section.