-
In today's tutorial, we will teach you how to make a line graph in Excel 2019.
Open the Excel document you need. We prepared a table with data for each month to use in this tutorial. Go to 'Insert' tab. Select the data you want in the graph. Click on Line graph and choose the style you like. Move and resize the graph if needed. You can see the selected data from the table is automatically added into the line graph.
Let’s change the look of the Chart. Select the Chart and click on the tiny arrow next to ‘Chart Styles’. Choose the look you like.
If you want to add another data right-click on the graph and choose 'Select data'. Click 'Add'. Put mouse pointer into 'Series name' field. Click on the data you need. Put mouse pointer into 'Series value' field. Select the value data. Click 'Ok' and 'Ok' again.
You can change or add chart elements. Click on the green plus icon on the right side of the chart. You can add 'Axis Title'. Simply check it. You can also add Data Labels and Data Table; Error Bars and Trendline or Up/Down Bars.
To edit 'Axis Title' click on it on the graph and put a name you want.
Ещё видео!