Mat N wrote:
Nikki,

Perhaps you could plot your values as their difference from the average
and use the auto scale (or if you are confident they'll be in a certain
range just have a fixed scale). Then hide this axis (or just the
values) and have a dummy axis or just floating values next to the axis
to indicate the max, minimum or average value.

This works good, so far. However, we would like to use a dynamic chart
(i.e. one that expands as we add data), as referenced at
http://peltiertech.com/Excel/Charts/...umnChart1.html. The
problem with this is that it uses the COUNTA function, and we are
including cells that have formulas included. ISNUMBER(in this cell), do
this, "") and the COUNTA function is including these cells into the
nonblank cell calculations. Is there another function we are
overlooking to accomplish what we're trying to do?

Thanks again for any help.