Maybe this idea will help.

Private Sub Chart_Activate()

ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = RANGE("B4")'bottom
.MaximumScale = RANGE("B5")'Top
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
' .MajorUnit = 500
.Crosses = xlAutomatic
.ReversePlotOrder = False
.ScaleType = xlLinear
.DisplayUnit = xlNone
End With
ActiveChart.Deselect
Application.ScreenUpdating = True
End Sub



--
Don Guillett
SalesAid Software

"Stan Altshuller" wrote in message
...
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