In this tutorial we learn how to create line chart in excel. Microsoft Excel provide best feature for creating line chart. When data represent through chart analysis on it easy. To create line chart first select data and click on insert menu. Now visit charts panel and select line chart. If want to design the inserted chart select chart and visit design menu’s chart styles panel.
Also change the color of line chart by using the change colors option of chart styles panel.
To change layout of chart use quick layouts option of the chart layouts panel.
If want to elements (like axes, data label, data table, error bars and grid lines etc.) to charts select add chart element from chart layouts panel. By adding an element to chart increase readability of chart.
create line chart in excel example:-
For creating line chart we use previous soap sales/month sheet. Which is following.
After selection of data click on insert menu and visit charts panel.
Select insert line chart from charts panel.
After clicking on the required 2D line chart chart insert into the sheet.
For changing the design of line chart select chart and visit design menu. In design menu there many designs of line charts.
After selection of required design chart become as.
For changing the colors use change colors option from chart styles panel.
After selection of color 3 from chart styles panel chart become as following.
For changing the layout of the chart select Quick Layouts from chart layouts panel.
After selecting layout 1 chart become as following.
For add element to created chart select that element from chart layouts panel “add chart elements”.
From Axes option change the axes of line chart.
When clicking on primary vertical chart become as following.
With help of data label option you can labeled the data represented by line.
Chart become as following after inserting the data labels.
You also insert data table into the chart for increase readability of chart by selecting data table option.
After inserting data table into chart the chart become as following.
Please follow and like us: