Every time and I mean EVERY TIME that I go to create a Candle Stick Stock Chart in Excel (otherwise known as an Open- High - Low -Close.
Tips to Understand this Video: Please read and understand the Title of the Video. Title is the main key to.
For example, to create a simple high - low -close stock chart, you should Volume - high - low -close This type of stock chart requires four series of values in the correct order (volume, high, low, and then close). Chart Styles on Excel Ribbon. How to Create Stock Chart High, Low, Close in Excel 2013 I then do some calcs to get the data into the right shape for the chart blue area and the chart is automatically refreshed for their requested slice — Voila! Possibly he was adding a data series to a stock chart, some kind of market index, and it was changing high low stock chart excel high-low lines for his stock data. Peltier Tech Blog Peltier Tech Excel Charts and Programming Blog Excel Chart Add-Ins. Choosing a style for the stock market chart Click on the stock chart. Right-click in the chart area, in the popup menu select Select Data.