How to create a Line Chart in Excel
How to create a Line Chart in Excel
Learn how to create a Line Chart in Microsoft Excel. This tutorial talks about what a line chart is and then demonstrates how to create a simple Line Chart in Excel with easy to follow steps.
Create a Line Chart in Excel (and sample data):
https://www.techonthenet.com/excel/ch…
Excel Charts:
https://www.techonthenet.com/excel/ch…
Excel Tutorials:
https://www.techonthenet.com/excel/in…
Don’t forget to subscribe to our channel for more great Excel tutorials!
Visit us at: https://www.techonthenet.com
or follow us on:
Facebook: https://www.facebook.com/techonthenetcom
Twitter: https://twitter.com/tech_on_the_net
Pinterest: https://www.pinterest.com/techonthene…
Content
0.32 -> In Excel, a Line chart is a graph that shows a series
of data points connected by straight lines
6.98 -> You can use a Line chart when
you want to show a trend over time
11.46 -> To illustrate how to create a Line chart,
let's look at an example
15.34 -> Here we have a table of data containing
monthly information for products
20.02 -> like desktop, laptop and tablet
22.72 -> Let's use a line chart
to graph this information
26.12 -> To get started, highlight the data that
you would like to use for the line chart
30.86 -> In this example, we have selected
the range A1:D7
35.14 -> Next, select the Insert tab in the toolbar
at the top of the screen
39.8 -> Click on the Line Chart button
in the Charts group
42.92 -> and then select a chart
from the dropdown menu
45.68 -> If you hover over each choice
in the dropdown menu
48.66 -> it will show you a preview of your data
in the highlighted chart format
53.08 -> In this example, we will select the fourth line chart
called "Line with Markers" in the "2-D Line" section
59.22 -> As you can see, our Line chart
has been created
63.3 -> Let's move this chart over a bit
to the left
66.3 -> This line chart shows the trend
for the 3 products
69.44 -> The blue series of data points
represents the trend for Desktops
73.18 -> The orange series represents Laptops
76.04 -> and the gray series represents Tablets
78.74 -> The axis values for each product
are displayed on the left side of the graph
83.88 -> Finally, let's update the title
for the Line chart
87.24 -> To change the title, click on the "Chart Title"
at the top of the graph object
91.98 -> Enter the text that you would
like to see as the title
95.6 -> In this example, we will enter "Product Trends by Month"
as the title for the chart
101.26 -> This completes our example of how
to create a Line chart in Excel
105.76 -> If you would like to see
more examples of charts
108.88 -> or would like to download
the sample data we used for this tutorial
112.12 -> please visit our website at
TechOnTheNet.com
115.44 -> If you have found our tutorial helpful,
please leave a like on this video
119.54 -> and don't forget to subscribe
to our YouTube channel for more great Excel tutorials
Source: https://www.youtube.com/watch?v=gpyqoVv3jgw