Related Topics:
	Chart Types

Hi-Lo Charts

Hi-lo charts are most commonly used to show stock market information. However, these chart types can also be used for scientific data such as indicating changes in readings over a period of time. The vertical (Y) axis shows values and the horizontal (X) axis shows categories or dates.

The application supports a number of variations to the hi-lo charts. These include: hi-lo-close with the close marker crossing the data point or extending to the right of the data point, open-hi-lo-close and open-hi-lo-close bar.

The data in the data grid must be organized appropriately for each variation of the hi-lo chart.

• A hi-lo chart requires two columns for each data series: the first column is used for the high point and the second is used for the low point.

• A hi-lo-close chart requires three columns for each data series: the first column is used for the high point, the second for the low point and the third for the closing point.

• An open-hi-lo-close or a open-hi-lo-close bar chart (sometimes called candle stick charts) requires four columns of data for each data series: the first column is used for the open point, the second for the high point, the third for the low point and the fourth for the closing point.

The column label on the first column in each series identifies the series in the legend. Additionally, any formatting applied to the first column is used to display the series on the chart. Any formatting applied to the remaining columns that make up the series is ignored.