Line Chart in Excel

In this blog post we will learn to create “Line Chart in Excel”. We will take simple example to create “Line Chart in Excel”. We have listed 05 products: Product A, Product B, Product C, Product D and Product E along with their costs.

Now we will see how we can convert this data into “Line Chart” for better data visualization.

Just follow below steps:

1. Select the above data which we want to convert into "Line Chart".

2. Go to “Insert” Tab, Select Insert Line Chart command under “Charts” group.

3. We will get further options for selecting Insert Line Chart. Out of these appeared option we have to select “Line” option as shown in below image.

4. We can see that “Line Chart” is now created for our selected data.

Changing Chart Style:

To change the formatting of our Line Chart, click on the existing “Line Chart” and this will appear two additional tabs on our Ribbon. These tabs are:

1. Design Tab

2. Format Tab

Once we click on the “Design” tab, we can see various Chart Styles for “Line Chart”.

As an example we can click on “Style 3” which will change the Style of our appeared “Line Chart” as shown in following image.

Similarly we can select any of the Chart Style from available options as per our own choice to give special effect to our Line chart.

Changing Color of Line Chart:

If we want to change the color of above created “Line Chart” then we have to select the existing “Line Chart” and then click on “Design” tab and then click on “Change Colors” option.

Once we click on “Change Colors” option, various color options will pop up on screen which we can use for our “Line Chart”. As an example we will click on the option “Color 3”.

Now, our “Line Chart” with “Color 3” and “Style 3” will look like as shown in below image:

Similarly we can try various Chart Styles and Color options to make our Pie chart beautiful.