Line charts are used to display trends over time. Use a line chart if you have text labels, dates or a few numeric labels on the horizontal axis. Use a scatter plot (XY chart) to show scientific XY data. To create a line chart, execute the following steps

Creating Chart. To create charts for the data by below mentioned steps. Select the data for which you want to create the chart. Choose Insert Tab » Select the chart or click on the Chart group to see various chart types. Select the chart of your choice a

Move your line graph. Click and drag the white space near the top of the line graph to move it. You can also move specific sections of the line graph (e.g., the title) by clicking and dragging them around within the line graph's window.