MarketXLS Charts – Candlestick Charts
To create a candlestick chart click on the candlestick chart button on the menu and provide OHLC and Volume Data.
You can also right-click on the chart to add any number series and annotate patterns on the candlestick charts. It's pretty self-explanatory overall and MarketXLS will prompt you to select series with annotations and patterns.
A pattern series only has binary data. That means if the pattern value is 0 it means there is no pattern and if it is 100 or -100 it means there is a pattern. Charts can be maximized to full screen and they automatically adjust dates etc depending on the size of the area.