Thanks for the testimonial. You've taken this very far, and it looks
very good.

When I can get people to think outside the box, as you have demonstrated
with your time scale axis labeling system, I feel that I've accomplished
something. What did we do in the old days, either with paper and ruler,
or with the most rudimentary plotting drivers? We measured the paper,
decided so many inches horizontally were worth so many units of the X
variable, and scaled the data accordingly; same with Y. Some of the best
charts I do are fancy dynamic charts with fully automatic scales linked
to cells, with custom labels, multiple scales in separate sections of
the chart including partial cycle log and reciprocal scales all in the
same chart. They do this without any VBA, but only with worksheet
formulas and a scaling philosophy similar to the first I ever used, when
I had use of an old (new at the time) HP-85 desktop computer (with a 3"
wide CRT screen and a thermal paper printer) to drive a two-pen plotter
by gunning an arcane version of BASIC to send HPGL commands to the
plotter. Excel's nice, it can give you axis scales and all, but you
don't have to use them if you can draw better ones yourself.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


centerNegative wrote:

Actually, here's a quick glimpse of what I was able to accomplish:
'
http://www.centernegative.com/mmds/ganttchart.jpg'
(http://www.centernegative.com/mmds/ganttchart.jpg)

The chart operates in 'real time', showing a different color for the
amount of a days a task is completed up to the current date. I haven't
gotten into drawing dependency lines and whatnot because that is not as
easily automated. What I have works well enough for now. It has also
allowed me to create tables that show projected monthly spending and
billings which is where the real importance lies.