Microsoft Excel Line Graph of A Stock

Finished Line Graph Example

Learn How to Make this Line Graph Example

1. Click the Chart Button on the toolbar across the top of the screen. If you do not see the button on the toolbar, go to Insert, and then scroll down to chart.



2. The Chart Wizard bar will appear, select Chart Type: Line.



3. Click on the appropriate chart that you want to use.






4. Click Next.



5. Click the Data Range Button to the right of the white box.





6. Highlight the Data Range in the appropriate columns. The X-axis should be the date of the stock check, while the y-axis is the prices of the stock on the days you checked your stock.





7. Click the Data Range Button, and you will return to the chart wizard.



8. Click Next.



9. Label the x-axis and y-axis. Also, give the Line Graph a title.





10. Click Next.



11. Then click Finished, and you have created a Line Graph of your closing prices.