Click one of those colors, and Excel applies it to the legend instantly. This flexibility gives you the ability to see how different legend colors look in relation to existing chart elements.

Excel automatically inserts a legend with default formatting at your selected location in the chart. You can then format the legend's font and change its location via the Legend Options panel.

Charts are great for showing comparisons and trends. In this tutorial, we will explain how to apply layouts and styles in a chart in Excel.