how to draw a line graph in excel

Line charts are used to display trends over fourth dimension. Use a line chart if yous have text labels, dates or a few numeric labels on the horizontal axis. Use a besprinkle plot (XY chart) to evidence scientific XY data.

To create a line chart, execute the post-obit steps.

1. Select the range A1:D7.

ii. On the Insert tab, in the Charts grouping, click the Line symbol.

3. Click Line with Markers.

Result:

Note: just if you accept numeric labels, empty prison cell A1 earlier you lot create the line chart. By doing this, Excel does not recognize the numbers in column A as a data serial and automatically places these numbers on the horizontal (category) axis. After creating the chart, you tin can enter the text Year into prison cell A1 if you like.

Permit's customize this line chart.

To change the data range included in the nautical chart, execute the post-obit steps.

4. Select the line chart.

5. On the Design tab, in the Data grouping, click Select Data.

6. Uncheck Dolphins and Whales and click OK.

Result:

To change the color of the line and the markers, execute the following steps.

vii. Right click the line and click Format Data Series.

The Format Data Series pane appears.

8. Click the paint bucket icon and modify the line color.

ix. Click Marking and change the fill color and border color of the markers.

Result:

To add a trendline, execute the post-obit steps.

10. Select the line chart.

xi. Click the + button on the right side of the chart, click the arrow next to Trendline and then click More Options.

The Format Trendline pane appears.

12. Choose a Trend/Regression type. Click Linear.

13. Specify the number of periods to include in the forecast. Type 2 in the Forrard box.

Result:

To change the axis type to Date axis, execute the following steps.

14. Right click the horizontal axis, and so click Format Axis.

The Format Axis pane appears.

xv. Click Date axis.

Result:

Conclusion: the trendline predicts a population of approximately 250 bears in 2024.

Source: https://www.excel-easy.com/examples/line-chart.html

Posted by: cashhincir.blogspot.com

Share this post