Microsoft KB Archive/97150

= Microsoft Knowledge Base =

Excel: ChartWizard Doesn't Add Close Marks to Stock Charts
Last reviewed: September 12, 1996

Article ID: Q97150

The information in this article applies to:


 * Microsoft Excel for Windows, versions 4.0 and 4.0a
 * Microsoft Excel for the Macintosh, version 4.0

SUMMARY
In Microsoft Excel version 4.0, the CHART.WIZARD macro command will not properly add close marks to a combination volume-high-low-close chart. If you manually run the ChartWizard, this error will not occur.

Workaround
To manually force the close marks to appear on a volume-high-low-close chart created by the CHART.WIZARD macro command, do the following:


 * 1) Double-click the chart to place it in a window.
 * 2) From the Gallery menu, choose Combination. Select format number 5. and choose the OK button.

The close marks should now be displayed on the chart.