Stock Price Charts

How to prepare stock chart using Open-high-low-close price(candlestick chart) using MS Excel.?

Open-high-low-close This type of chart requires four series of values in the correct order (open, high, low, and then close).

Public Comments

1. you must have 5 columns of data(numbers), including date column as first column, with column's titles to start with, then you have to start the graph by clicking the bar graph icon on menu bar 1. choosing "Stock", and the chart sub-type is "Open-High-Low-Close" 2. For data range tab, choose columns 3. For Series tab, check each series on the left to see if the range on its right is correct 4. click next and check out the rest of the minor attributes and tune it to your preference. Hope this helps