Close
    Search Search

    How to caption a chart in Excel?

    How to caption a chart in Excel?
    Using a chart in Excel makes a table more readable and especially to identify key figures in a few seconds. In this tutorial we will add a legend to our graph, but also customize the appearance of the legend, including the font, and its color.

    Label a chart in Excel

    1. Click on the graph to which you want to add a caption, click the Chart Elements button + And click Legend.

      How to caption a chart in Excel?



    2. To change the position of the legend, click on the arrow to the right of the legend, then select the desired location. How to caption a chart in Excel?

    By default, a legend is not allowed to overlap a chart. But if you're short on space, it's possible to reduce the size of the graph by clicking on More options, then unchecking the box Show legend without covering the graph.

    To delete a caption, right-click it, then click Delete

    Change the font or size of legends in an Excel chart

    1. Click with the right button of your mouse on the legend, then click Police. How to caption a chart in Excel?

    2. In the Font tab, make any desired changes like font size or color. How to caption a chart in Excel?

    3. When finished, press the button Ok to see the result on your Excel spreadsheet. How to caption a chart in Excel?

    The legend of a graph may seem trivial to you, but it is an essential element of the representation. Excel allows you to highlight your legend by adding an effect to it: shadow, glow, softened outline, etc. Be careful not to overload the legend to the detriment of your graph!

    40 ">This tutorial is brought to you by the trainer Jean-Philippe Parein
    Find his course Learn and Master PowerPoint Complete Guide
    in full on Udemy.
    add a comment of How to caption a chart in Excel?
    Comment sent successfully! We will review it in the next few hours.