After reading the Japanese Candlestick Charts in Excel post, Gene asks me in an email,
I’m trying to graph candlestick charts in Excel for 10 minute candles. Excel seems to allow daily only with its stock templates. Can you point me to any resources for creating intraday candle charts?
Of course, being the smart person Gene is, he figured out that even before I could send an email back (he used box plots to mimic 10 minute candles)
But there should be a way to make intraday candlestick charts using the regular stock chart in excel. Isn’t it?
Well, there is a way.
As an aside, you might wonder what an intraday candlestick is?
Well, I am no day trading expert nor a technical analyst of stock markets, but statistically speaking, there can be high, low, open and close values for any given interval. Although, on a busy day, you might find that close of a 10 minute interval is equal to open of the next 10 minute interval. But, these days, the stock markets are seldom busy (unless you are busy selling 😉 ). Again, I digress. So going back to the intraday candlestick charts,
1. First get the intraday stock price movement data
2. Now, Create a regular candlestick stock chart
When you are done, the chart should look something like this:
3. Select date axis (horizontal axis) and press ctrl+1 (or right click and go to format axis)
And change the axis type from “date” to “text”
Also, set the interval between labels to 3 or something like that. This will reduce the label clutter.
That is all. You will now have an intraday candlestick chart that looks like this:
Download the intraday candlestick chart template and play with it.
8 Responses to “Create a Combination Chart, Add Secondary Axis in Excel [15 Second Tutorial]”
[...] Select the “daily completed” column and add it to the burn down chart. Once added, change the chart type for this series to bar chart (read how you can combine 2 different chart types in one) [...]
[...] set the height series to be plotted on secondary axis. Learn more about combining 2 chart types and adding secondary axis in [...]
[...] Excel Combination Charts – What are they? [...]
[...] To show the years, I have used another dummy series and plotted it on secondary axis (related: how to add secondary axis?) [...]
Thanks for this one!
[...] Choisissez la colonne « Daily Completed » et ajoutez-la au graphique. Une fois ajoutée, changez le type de graphique pour cette série à histogramme (lisez comment combiner 2 types de graphiques en un : combine 2 different chart types in one) [...]
How do i create a chart that has negative numbers on axis x and y and plot them correctly? I cannot seem to understand how to do this, please help.
Thanks.
Nat
You can also plot 2 or more Y axes in Excel using EZplot or Multy_Y from Office Expander.com
There is a demo version to try.
Cheers.