Introduction

This tutorial will show you how to create stock charts in excel. We will be using Microsoft Excel 2003 and stock prices from Yahoo Finance.

How to manually copy stock prices into excel.
Select an optional stock in Yahoo Finance. Copy the whole datarange from "Historical prices".

From date down to the last data. Select "paste special.." in Excel and choose "text".

Insert the stock chart
Select all the data under "High", "Low" and "Close" in your excel sheet.

Select "Insert" and "Chart..." in the top menu in Excel.

Press "Finnish".

Chart settings
To change the gray background to white press with the right mouse button on the grey area and select "Format plot area". Choose within the "Area" window none or whatever background color you want.