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

Posted by admin on November 30th, 2009 and filed under stock chart | 1 Comment »

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

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

One Response

  1. AQuestionMark Says:

    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
    References :

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.