How To Draw A Line On Excel Graph
Line charts are used to display trends over time. Apply a line chart if y'all have text labels, dates or a few numeric labels on the horizontal centrality. Use a scatter plot (XY nautical chart) to show scientific XY data.
To create a line nautical chart, execute the following steps.
1. Select the range A1:D7.
ii. On the Insert tab, in the Charts group, click the Line symbol.
3. Click Line with Markers.
Result:
Note: just if you accept numeric labels, empty prison cell A1 before you create the line chart. By doing this, Excel does non recognize the numbers in column A as a data serial and automatically places these numbers on the horizontal (category) centrality. After creating the chart, yous tin can enter the text Twelvemonth into cell A1 if you like.
Let's customize this line chart.
To change the data range included in the chart, execute the post-obit steps.
iv. Select the line chart.
5. On the Design tab, in the Information grouping, click Select Data.
vi. Uncheck Dolphins and Whales and click OK.
Consequence:
To modify the color of the line and the markers, execute the following steps.
7. Right click the line and click Format Information Series.
The Format Data Series pane appears.
viii. Click the paint bucket icon and change the line colour.
9. Click Marking and change the fill colour and edge colour of the markers.
Event:
To add together a trendline, execute the following steps.
10. Select the line chart.
xi. Click the + button on the right side of the chart, click the arrow next to Trendline and so 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 Forward box.
Result:
To modify the axis blazon to Date centrality, execute the following steps.
14. Correct click the horizontal axis, and then click Format Axis.
The Format Axis pane appears.
fifteen. Click Engagement 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: troupeingthe.blogspot.com
0 Response to "How To Draw A Line On Excel Graph"
Post a Comment