Posted by Steve Wasylkowski on April 20, 2001 12:02 PM
HELLLLLP! I am trying to create scatter chart in Excel 2000. X axis will be S&P 500 return, y axis will be Portfolio return. Values will run from -20% to +20% for each axis. I would like these values reflected outside of the actual scatter chart. I would like to plot a straight 45 degree line to reflect equal returns for portfolio & S&P. Then I would like to plot (portfolio return - S&P return). This plot would just be dots showing the relative value of portfolio vs S&P. If the dot is above the 45 degree line it's good, meaning portfolio outperformed S&P. A dot below 45 degree line would be bad (underperformance).
How would you set up something like this?