Add a data series to a chart in Excel. Show a new data series in your chart (graph) by including the series and its name in the chart source data.

To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update …

By adding lines, including series lines, drop lines, high-low lines, and up-down bars, to specific chart can help you analyze the data that is displayed. If you no longer want to display the lines …

Use chart filters to show and hide data series or categories, and use the Select Data Source dialog box to further change and rearrange the data that's shown in your chart.

Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.

You should see the Format Object Task Pane on the right-hand side of the Excel window. If the Series Options aren't already displayed, then click the Series Option expander button on the …

To add a new legend entry, type the reference to the worksheet cell or type a new name and then, in the Series values box, type a reference to the data series on the worksheet that you want to …

For example, in the pie chart below, without the data labels it would be difficult to tell that coffee was 38% of total sales. You can format the labels to show specific labels elements like, the …

The name you type appears in the chart legend, but won't be added to the worksheet. To change the data range for the data series, in the Series values box, type a data range for the data …

Set varying colors of data markers (bars, columns, lines, pie or doughnut slices, dots, and other shapes) automatically in an Office chart.