I think I may have figured it out. It wasn't working because I am only
graphing 1 data point, but it couldn't chart the area for 1 point (it was
just a blank graph, but with the right axis labels). Then I added another
cell with the same value as the first and now it charts the correct area.
I'm not sure if that was the right way to "trick" it into charting it? I
have a dynamic value in my source data because the area to be charted will be
changing every week.

"Jon Peltier" wrote:

It works the same as with other chart types. What steps have you followed,
and what is not working the way you expected?

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


"kal4000" wrote in message
...
Is it possible to create a dynamic area chart - an area chart which
updates
its values when new data is entered? I can't seem to make it work.