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.

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.

I had already looked at your site earlier, which provides lots of cool ideas.
But of course, not my particular problem. If anyone can figure it out, it
will be you! I look forward to the solution. THANKS for pursuing this!

"Jon Peltier" wrote:

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.