|
Peltier Tech
Buy me a coffee If this topic or the whole site has been helpful, please support further development by treating me to a cup of coffee. |
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.Commercial Utilities | Custom Solutions | Training | Charts and Tutorials | PTS BlogPeltier Technical Services, Inc., Copyright © 2010. All rights reserved. |