AJP Excel Information AJP Excel Information

Re: Point-and-figure (type of stock market chart) in Excel

The workbook contains three ways of achieving the same look.
The important part of the example is the VBA code used to generate the chart data according to
the guidelines for Point & Figure charts.

this chart is a xy-scatter. Two data series with appropriate looking markers.
This is a stacked column with a scaled picture fill.

This is also a stacked column with solid colour.
Please Note:
This example has not been tested beyond the small example given in a tutorial I located on the web.

Created August 2004
Last updated 28th April 2007 

Return to main page Chart Section VBA section Fun and games section Forum files Tips section Links section Book section Site information Site Search RSS feed Top of page

Microsoft® and Microsoft® Excel are registered trademarks of the Microsoft Corporation.
andypope.info is not associated with Microsoft. Copyright ©2007-2016 Andy Pope