Candlestick Chart in Excel

August 14th, 2004 | Categories: Charts | Tags:
-->

If you’re not familiar with Excel, the Open-High-Low-Close style chart is actually a Candlestick Chart. Here’s how to make one.

1. Select the range of data that includes the headers and fields for Open-High-Low-Close

2. Open the Chart Wizard (click the chart icon on your toolbar)
3. Select the “Stock” chart Type
4. Click the Open-High-Low-Close Sub-Type

5. You can click Finish to view your chart, or change the look and feel of your candlestick chart by going through the rest of the wizard.

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. jody
    April 14th, 2009 at 05:22
    Reply | Quote | #1

    thanks for the having this website, i found it very useful…i was kind of loss trying to figure out how to chart a candlestick,but after taking a look on the site , i just can do it….

  2. BxCapricorn
    October 9th, 2009 at 12:53
    Reply | Quote | #2

    I posted an on-line Google document with my collection of Excel based candlestick recognition formulas.

    http://docs.google.com/Doc?docid=0AWIwmWo21U8sZGZmejk2NnFfMjQ5Y3F0a2tmZ3E&hl=en

    Please feel free to test and share.

  3. Horst
    May 22nd, 2011 at 11:03
    Reply | Quote | #3

    very good explanation thanks