I've taken on the challenge. It's related to the VBA shape-drawing
procedures on this page:
http://peltiertech.com/Excel/Charts/VBAdraw.html
but the smoothing of the segments of the drawn polygon have taken me a
while to decipher, and the article will also take a while. Look for a
new web page or article "soon". It will be listed he
http://peltiertech.com/Excel/Charts/NewStuff.html
and if I remember, I'll post another response to this thread.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
Gail wrote:
I want an stacked area chart, but the lines go from point to point. I really
want the area chart with a SMOOTHED line instead, as the data gradually rises
and falls between readings. Is there a way to do this? I have Excel 2003.