Modifying Hi-Low Close-Volume Chart so Volume Uses Line Format

 Last reviewed: November 3, 1994
Article ID: Q72871
The information in this article applies to:
  • Microsoft Excel for Windows, versions 2.x, 3.0, 4.0, 4.0a, 5.0
  • Microsoft Excel for OS/2, versions 2.2 and 3.0

SUMMARY

With the default hi-lo close-volume chart in Microsoft Excel, the volume is always represented as columns. To modify the chart so that volume is represented by a line instead of columns, choose Main Chart from the Format menu and change the main chart type from Column to Line.

MORE INFORMATION

A hi-lo close-volume chart is created by using four series of data. The default format for a hi-lo close-volume chart is the Fifth Combination command in the Gallery menu. It displays the volume (4th series) in the column format. When you use a combination chart, each series is separated into a main chart and an overlay. In a hi-lo close-volume chart, the volume is the main chart and the hi, low, and close series make up the overlay. To modify the volume, modify the main chart.

For example:

  1. Using four columns of data from your worksheet, create a chart.

  2. From the Gallery menu, choose Combination and select the fifth option.

  3. From the Format menu, choose Main Chart.

  4. From the Main Chart Type box, select Line. Choose OK.

REFERENCES

"User's Guide 1," version 4.0, pages 406-431

"Microsoft Excel User's Guide," version 3.0, pages 408-425

KBCategory: kbusage
KBSubcategory:

Additional reference words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0
3.00 4.0 4.00 4.00a 5.00

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 3, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.