The histogram is plotted from a table of bin ranges and counts. If you
change those table values into formulas, then the histogram will update with
those formulas.

Jerry

"Mike Williams" wrote:

In Excel 2003 SP2. I have created a form for reporting Statistical
values.This includes a normal distribution chart. I want to update this chart
when new sample data is entered into the form, without having to go through
"Tools, Data Analysis, Histogram" each time. I have already tried recording
my steps, with "Record New Macro" in the tools menu, but this does not work.