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.

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 …

On the Design tab, in the Chart Layouts group, click Add Chart Element, choose Data Labels, and then click None. Click a data label one time to select all data labels in a data series or two …

Sometimes you need to remove a chart or graph to unclutter the space of your spreadsheet or make the rest of the information stand out. When you delete a chart, the data you have used …

After creating a chart, you might need to add an additional data series to the chart. A data series is a row or column of numbers that are entered in a worksheet and plotted in your chart, such …

On the worksheet, click the cell that contains the name of the data series that appears as an entry in the chart legend. Type the new name, and then press ENTER.

To reposition all data labels for an entire data series, click a data label once to select the data series. To reposition a specific data label, click that data label twice to select it.

You can show or hide the legend of a chart. Showing a legend can give readers more information about the chart, while hiding a legend can give your chart a cleaner look.

In the chart, select the data series that you want to plot on a secondary axis, and then click Chart Design tab on the ribbon. For example, in a line chart, click one of the lines in the chart, and all …

Tip: Make sure that only one data label is selected, and then to quickly apply custom data label formatting to the other data points in the series, click Label Options > Data Label Series > …