How to display numerical values in excel line chart

How to display numerical values in excel line chart?

You can add data labels to this polyline.

1. Take the excel2010 version as an example, as shown below. To display the vertex values on the line chart, first click on the line chart, and then select "Add Data Label" in the pop-up box;

2. You can see that the value has been successfully added to the line chart. At this time, you can click on any value, then right-click the mouse and select "Set Data Label Format" in the pop-up box. ;

3. In the pop-up setting box, select the location you want to display for the label position. Select the bottom here, and finally click Close below;

4. As shown in the figure below, you can see that the breakpoint values are displayed at the bottom.

For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn!

The above is the detailed content of How to display numerical values in excel line chart. For more information, please follow other related articles on the PHP Chinese website!