Stan,

Regarding question 1, you can add equations to charts by plotting points in
an Excel worksheet and then charting those points. For more detailed
information, Stephen bullen has some excellent examples of how to plot
functions . . .

http://www.bmsltd.ie/Excel/Default.htm

Regarding question 2, please refer to Jon's site for how to create dynamic
charts . . .

http://peltiertech.com/Excel/Charts/...umnChart1.html

http://peltiertech.com/Excel/Charts/Dynamics.html

The entry below might help with setting a dynamic Y axis via code . . .

http://www.pdbook.com/index.php/excel/tie_y_axes/


"Stan Altshuller" wrote:

Hi all,
two questions:

1. I have a scatter plot of returns and I want to add not a trend line but
simply x=y line to my plot (and other equations)
Any way to do this?

2. I need to control both my x and y axis, I want to max and min and scale
numbers to be linked to a cell in my spreadsheet instead of simply being
static values or auto.

THANKS!
Stan