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 the Excel Basic Tutorial column!

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!