Re: Category Axis placement

You could have an activate event macro, something like

Private Sub Chart_Activate()
ActiveChart.Axes(xlValue).ActiveChart.Axes(xlValue).CrossesAt =
Worksheets("Sheet1").Range("A1")
End Sub


Where Range A1 contains the figure you want the axis to cut through. A1
will have a formula like =MIN(A1:A10)

This is just for you to get an idea.

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.ph...fo&userid=10470
View this thread: http://www.excelforum.com/showthrea...threadid=376715