2. Select the title line, and click Data and Filter; For example, as shown in the figure
3. Click the down arrow on the right side of the "Company" cell and select "Company A" as needed; For example, as shown in the figure
4. The appearance after screening is shown in the figure;
5. Select the data cell in the column "Per capita consumption (yuan)"; For example, as shown in the figure
6. Click the down arrows "Insert" and "Line Chart" in the lower right corner of the menu, select "Line Chart" (the name of the chart will appear when the mouse is placed on the corresponding chart), and click; For example, as shown in the figure
7, will jump out of the corresponding broken line graphics; For example, as shown in the figure
8. Select the polyline in the drawing and the corresponding chart tool will appear. Select the layout. For example, as shown in the figure
9. Select the small arrow in the lower right corner of the data tab, and several options will appear; For example, as shown in the figure
10, there is no direction requirement for the data, so we just choose one at random and choose "below" here; For example, as shown in the figure
1 1, so that the "line chart marked with data" is completed. For example, as shown in the figure