Candlestick charts are used to represent rises and falls in stock values. These charts are similar to high-low charts but are more complex, requiring two additional columns. For any given category, a graphic is shown consisting of a box with lines protruding from the top and bottom, hence the name "candlestick." As in a high-low chart, the ends of the lines represent the high and low prices for the stock respectively. The top and bottom boundaries of the box represent the opening and closing prices of the stock. If the opening price of the stock is lower than the closing price (that is, the stock gained value), the graphic appears green. If the opening price is higher than the closing price (that is, the stock decreased in value), the graphic appears red.
Powering candlestick charts
Candlestick charts require five columns or rows of data from your DataSet—a category column or row containing the name of each stock or the dates if you are showing a time progression for a single stock; and four columns or rows with the values. One of the columns or rows contains low values for the stocks or dates; one contains closing values; one contains opening values; and one contains high values. For information about value, category, and series data, see Understanding Chart Data.
In the Analyzer, you choose the columns containing the data for your candlestick chart. For more information about choosing data columns, see Applying DataSet Columns to Your Chart.
For more information about formatting charts in the Analyzer, see KPI Card Building Part 2: The Analyzer.
The following graphic shows you how the data from the category and value columns in a typical column-based spreadsheet is converted into a candlestick chart:
Customizing candlestick charts
You can customize the appearance of a candlestick chart by editing its Chart Properties. For information about all chart properties, see Chart Properties.