Two types of chart on one chart

[Rob graham]

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]

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/straight_lines/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_charts_horizontal_line.htm

Cheers
Andy

 

[Rob graham]

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/straight_lines/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_charts_horizontal_line.htm

Cheers
Andy

Thanks Andy.