Peltier Technical Services, Inc.
 

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

Peltier Tech
Chart Add-Ins

Peltier Tech Waterfall Chart Utility
Peltier Tech Cluster-Stack Chart Utility
Peltier Tech Box and Whisker Chart Utility
Peltier Tech Marimekko Chart Utility
Peltier Tech Dot Plot Utility
Peltier Tech Cascade Chart Utility

 

Excel Dashboards

 

Books at Amazon.com

  

In Cell Charting With Shapes

I've recently had projects which had difficult charts to make. The charts themselves were easy, really they were just simple stacked bar charts. The problem is that the charts corresponded to data in tables which could vary in number of rows, depending on the results of a query. It is very difficult to format the dimensions of an excel chart reliably, especially when the user may not be viewing the window at 100%. Changing the zoom from 100% to 125% may result in a chart that suddenly is three or four rows too long, so it is completely out of synch with the rows of data it is plotting.

The answer is to construct the chart with autoshapes. The shapes are aligned precisely within their respective rows, and the code to redraw them as the data is updated is remarkably quick and neat.

 

 

 

 

Page copy protected against web site content infringement by Copyscape

 

Peltier Tech Waterfall Chart Utility Peltier Tech Cluster-Stack Chart Utility Peltier Tech Box and Whisker Chart Utility Peltier Tech Marimekko Chart Utility Peltier Tech Dot Plot Utility Peltier Tech Cascade Chart Utility

 

Create Excel dashboards quickly with Plug-N-Play reports.

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

Microsoft Most Valuable Professional

My MVP Profile