Line of best fit on a Histogram

Jazz -

You can add a trendline to a column chart. Select the series, and choose
Add Trendline from the Chart menu.

Given the curve fitting parameters, you can define predicted Y values
for each of the columns. For X values, use the integers 1 through N,
where N is the number of categories (Excel uses 1 through N in
calculating its trendline for a non-scatter chart). Add this data to the
chart, then right click on the new series, select Chart Type from the
pop up menu, and change it to a line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

JazzV wrote:

Hi all

Does anyone know if its possible to draw a line of best fit on a
histogram. I have worked all the line of best fit points but i cannot
seem to get it to draw itself into the histogram.

Thanks for all your help!!

Jazz