How do I add median lines to a scatter chart?
 

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?

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?

How do I add median lines to a scatter chart?
 

jwalsh2000 wrote on Thu, 18 May 2006 11:37:02 -0700:

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

I'm not familiar with the graphs you mention. Could you give an
example, perhaps a URL, and let me me know if you really mean
the *median* as opposed to the mean or mode?

James Silverton.