Peltier Technical Services, Inc.
- Custom Excel Solutions
Jon's Excel and Charting Pages
- Jon's Charts
- Tutorials
- Excel
- Site Index and Search
- RSS
|
Peltier Technical Services, Inc. Jon's Excel and Charting Pages |
|
In Cell Charting With ShapesI'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. Jon's Excel and Charting Pages Peltier Technical Services, Inc., Copyright © 2008. All rights reserved. |
Waterfall Chart
Box and Whisker
