Creating high/low charts

You can use high/low (open/close) charts to track daily stock prices. You need at least two series of data to create this type of chart (to represent the highest and lowest stock prices reached each day).

The type of high/low chart that you can create depends on the number of data series that you want to plot.

If you want to plot
Chart types available
Three series of data
High/Low — The third series is not used in the chart.

High/Low/Open — The third series represents the opening value (the price of the stock at the beginning of the business day).

High/Low/Close — The third series represents the closing values (the price of the stock at end of the business day).
Four series of data
High/Low/Open/Close — All four series are used in the chart.

High/Low/Open or High/Low/Close — The fourth series is not used in the chart.

High/Low — The four series represent the data of two companies.
Five series
High/Low/Open/Close/Volume — The fifth series is used to plot the trading volume.

High/Low/Open — The third series represents the opening value (the price of the stock at the beginning of the business day). The fourth and fifth series are discarded.

High/Low/Close — The third series represents the closing values (the price of the stock at end of the business day). The fourth and fifth series are discarded.

High/Low/Open/Close — The first four series are used, and the fifth series is discarded.

A common use for the fifth series is to display the volume data, or number of shares of stock that changed hands on a given that day. Volume data is usually much larger than high/low data, so the high/low data does not show up well in the chart. The high/low bar chart has special formatting to correct this problem. The first four series are plotted as they would be in regular high/low charts. The fifth series, however, is plotted as bars against the secondary y-axis. The secondary y-axis scale is adjusted to plot the bars on the lower quarter of the chart, where the bars are unlikely to cover the high/low values.

Wordperfect Quattro Pro charts highlow sample Creating high/low charts

A high/low/open/close chart. The tick marks show the stock’s highesr and lowest prices.

For information about modifying high/low charts, see “Changing high/low chart options” and “To change the data range of a series in a high\low chart.” For information about editing charts, see “Editing charts.”


To create a high/low chart

Wordperfect Quattro Pro btnbacktotopproc Creating high/low charts
1.
 
Select the cells you want to plot.
If the surrounding cells contain explanatory labels, you can include them in the selection for use as the chart axis labels or the chart legend.
2.
 
Insert Wordperfect Quattro Pro onestep Creating high/low charts Chart Wordperfect Quattro Pro onestep Creating high/low charts Use Chart Expert.
3.
 
Click Next.
4.
 
Choose High low from the Category list.
5.
 
Click one of the following area chart options on the Type palette:
•
High low Wordperfect Quattro Pro chart high low Creating high/low charts
•
High low open Wordperfect Quattro Pro chart high low open Creating high/low charts
•
High low close Wordperfect Quattro Pro chart high low close Creating high/low charts
•
High low open close Wordperfect Quattro Pro Creating high/low charts images/chart_high_low_open_close.jpg" height="16" width="16" border="0" hspace="0" vspace="0">
•
High low open close volume Wordperfect Quattro Pro chart high low open close vol Creating high/low charts
6.
 
Click Next.
7.
 
Type in any of the following boxes:
•
Title
•
Subtitle
•
X-axis
•
Y-axis
•
Footnote
8.
 
Click Next.
9.
 
Choose a color scheme option from the Choose a color scheme list.
10.
 
Click Finish.
11.
 
Drag in the spreadsheet.

Wordperfect Quattro Pro tip Creating high/low charts

•
 
You can add depth to a chart by enabling the Add depth check box. You can also apply advanced rendering to a chart by enabling the Advanced rendering check box.

Creating high/low charts