Add data labels to a chart. Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data Labels. To change the location, click the arrow, and choose an option.

If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), you can edit those titles and labels.

In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart). Your chart uses text from its source data for these axis labels.

Change the text and format of category axis labels and the number format of value axis labels in your chart (graph in Office 2016 for Windows. You can also set other options in the Format Axis task pane.

You can add predefined lines or bars to charts in several apps for Office. 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 or bars, you can remove them. New to formatting charts in Excel?

You can use leader lines to connect the labels, change the shape of the label, and resize a data label. And they’re all done in the Format Data Labels task pane. To get there, after adding your data labels, select the data label to format, and then …

Select a chart to open Chart Tools. Select Design > Change Chart Type. Select Combo > Cluster Column - Line on Secondary Axis. Select Secondary Axis for the data series you want to show. Select the drop-down arrow and choose Line. Select OK.

Create a line chart. Select the data you want to plot in the chart. Select the Insert tab, and then select Line, and pick an option from the available line chart styles. With the chart selected, select the Chart Design tab to do any of the following: Select Add Chart Element to modify details like the title, labels, and the legend.

On the worksheet, in the cells directly next to or below the source data of the chart, type the new data and labels you want to add. Click the chart sheet (a separate sheet that only contains the chart you want to update).

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.