In Cell Charting With Shapes

I've prepared this page as my response to the More on Excel in-cell graphing blog entry in the Juice Analytics blog.

It's really not too complicated to write a VBA procedure to process a table of numbers. In the picture here:

I show a small sample of a large worksheet. I've left out the proprietary data. Each cell in the column displays a number of values. The width of the outer rectangle reflects the high-medium-low importance of a record, the width and position of the filled rectangle within it indicate something about the range of values of some property of the record. The colors of the outline and filled rectangle indicate other values, and the blue vertical line indicates something else. It looks complex, but the client is able to scan hundreds of rows of these graphics and pick out the records with the criteria he is interested in, much more quickly than if he had to stare at tables of numbers, even if they were conditionally formatted. The code only took a few hours to bang into shape, and it runs in under a second.

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Custom Solutions | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2010. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

My MVP Profile