MrDiablo2327

Looking for help with graphs in Excel. Have a large data set that I am trying to plot. Because of size, I have formated the x-axis as logarithmic scale. When doing this, the y-axis automatically shifts to the center of the plot. I would like to supress this response, either through code and/or a property setting.
Thanks.

Peter_Aquino

I think what you're looking for is the .CrossesAt property of the Chart.Axes object. This property specifies where one axis will cross another. So you would set the value to '1' for the X Axis.