Area chart with smoothed line

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 here:

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 here:
>
> 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.
>