View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme
 
Posts: n/a
Default How do I add median lines to a scatter chart?

To add a horizontal line to a chart see any of these

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

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jwalsh2000" wrote in message
...
I am trying to replicate some graphs from a financial reporting packege in
Excel. I plot the risk & return for all of the funds in a fund universe
into
a scatter (xy) graph. I now need to add lines that would indicate the
median
of buth my x & y data. This is a very common investment graph - can this
be
done in Excel?