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