Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date in scatter chart excel 2003 | Charts and Charting in Excel | |||
Scatter chart without numerical values | Charts and Charting in Excel | |||
Line chart or scatter chart?? | Excel Discussion (Misc queries) | |||
Missing lines in chart w/x-axis with months 1-24... | Charts and Charting in Excel | |||
Leader Lines Connecting Chart to Box | Excel Discussion (Misc queries) |