"Andy Pope" wrote in message
...
Hi,

Here is a collection of sites that explain how to add a datum line to a
chart.
http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

Cheers
Andy

Rob graham wrote:
I have a bar chart of annual rainfall. I wish to place a horizontal line
plot across the bars signifying the average over the years. I don't know
how to put these two types of chart on one chart. Can anyone help?

Thanks

Rob Graham

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy.