An Excel chart's legend identifies its data series markers. For example, if a chart compares several products' sales, colored lines track each product. The legend contains colored lines as well ...

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.

Launch Excel. Create a table or use an existing table. Highlight the data in your table. On the Insert tab in the Charts group, click the See All Charts arrow. An Insert Chart dialog box will open.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.

This technique lets you build an Excel chart that shares supportive information in series form. Select the data labels and data. In this case, you’d select A1:D5.

Your updated table containing the bull’s-eye circle data should now appear as shown below. 5. Add the concentric bull’s-eye circles to the chart. Plot the outer circle of the bull’s-eye chart by right ...