PTS Blog

Main menu:

PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart

Excel Books

Books that I own and use while developing in Excel

Goods and Services

Excel or charting related products and services which I use or feel are worthwhile additions

Subscribe

Site search


Recent Posts

Recently Commented

July 2008
S M T W T F S
« Jun   Aug »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Archive


 

Categories


 

Archive for Thursday, July 3rd, 2008

Dynamic Chart Source Data

by Jon Peltier
Peltier Technical Services, Inc., Copyright © 2008. All rights reserved.

A dynamic chart can be constructed using dynamic ranges that change in size as data is added or removed. This technique is very powerful: you can define flexible ranges limited only by your ability to write an appropriate Refers To formula.
One imitation of this approach is that it can only account for dynamic numbers of [...]

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