Dont want chart to include origin

[ThomasOES]

Hello

My xyScatter chart has an annoying habit of always including the origin. Often I'm only interested in the immediate range of the data being plotted.
Is there a method to disregard the origin? I've included the code for the chart data. I would like a chart property that "zooms" in on the data range.


'ActiveChart.SeriesCollection.NewSeries
' ActiveChart.FullSeriesCollection(1).Select
' With Selection
' .XValues = Range("StdCalc")
' .Values = Range("StdVal")
' .MarkerStyle = xlMarkerStyleX
' .MarkerSize = 10
' .MarkerForegroundColor = RGB(0, 0, 200)
' End With

Thanks for any advice

Tom

 

[pgc01]

Hi Tom

Set the maximum and minimum values for the axes according to the values.

For ex.
- if the values in the X axis have a minimum value of 21.34 set the minimum for the X axis equal to 21 or 20.
- if the values in the Y axis have a maximum value of 43.56 set the maximum for the Y axis equal to 44 or 45.

This way you define the range that you see as a rectangle that includes all the values but not much more.

(the axes properties are .MaximumScale and .MinimumScale)