I would like a chart that updates for daily sales statistics over the course
of the month without dragging a formula, such that I enter the day's sales,
and the chart updates for the new day (to be viewed against a target line).
I do not want the chart to show the "zero" value for days which have not yet
occured. I tried using a formula, but all formula results register on the
chart (i.e. if the formula result is blank, or space, or a word, the chart
plots a point at zero). I need it for a cummulative sales number day by day.


Thanks!

Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html


Ben Morton wrote:
I would like a chart that updates for daily sales statistics over the course
of the month without dragging a formula, such that I enter the day's sales,
and the chart updates for the new day (to be viewed against a target line).
I do not want the chart to show the "zero" value for days which have not yet
occured. I tried using a formula, but all formula results register on the
chart (i.e. if the formula result is blank, or space, or a word, the chart
plots a point at zero). I need it for a cummulative sales number day by day.


Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

#N/A, or equuivalently NA(), does not plot

Jerry

Ben Morton wrote:

I would like a chart that updates for daily sales statistics over the course
of the month without dragging a formula, such that I enter the day's sales,
and the chart updates for the new day (to be viewed against a target line).
I do not want the chart to show the "zero" value for days which have not yet
occured. I tried using a formula, but all formula results register on the
chart (i.e. if the formula result is blank, or space, or a word, the chart
plots a point at zero). I need it for a cummulative sales number day by day.


Thanks!

-----Original Message-----
Jon Peltier has information on creating dynamic charts:

http://www.peltiertech.com/Excel/Charts/Dynamics.html


Ben Morton wrote:
I would like a chart that updates for daily sales
statistics over the course
of the month without dragging a formula, such that I
enter the day's sales,
and the chart updates for the new day (to be viewed
against a target line).
I do not want the chart to show the "zero" value for
days which have not yet
occured. I tried using a formula, but all formula
results register on the
chart (i.e. if the formula result is blank, or space,
or a word, the chart
plots a point at zero). I need it for a cummulative
sales number day by day.


Thanks!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.