In this article we will learn how we can make the Line graph in Excel.
Line Graph is used to show trends over time (years, month, and days) or categories in Microsoft Excel 2010 and 2013.
Line Chart contains7 types of line charts. Line chart, Stacked Line, 100% stacked line, Line with Markers, Stacked line with Markers, 100% stacked line with markers, and 3D Line.
Let’s take an example and understand how we can use line chart in excel.
We have month wise achievement data. In which column A contains Month Name and column B contains Achievement.
Let’s see how this is achieved. To create the line chart follow below givensteps:-
If you wanted to add more data in the chart, let’s say we added the targets in column C how we add the data in chart?
To make it double line graph we will add the data in chart.
There is 2 another ways to add the data in the chart.
1. Click on the chart, you will see the data will get selected with the colored lines. Just click on blue line with the mouse and hold it and drag it till C13 (End cell of data).
2. Click on the chart 2 contextual tabs will get active in the ribbons. In the Design tab click on Select data in the data group.
a) Select Data Source dialog box will get appear.
b) Click on the Chart data range tab.
c) Select the range A1:C13, again click on Chart data range tab.
d) Click on ok.
This is the way we can prepare the Line chart and can add the more data in chart.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.