help with graph scaling

[mcb7722]

I have two sets of data, one which reflects the other exactly (ie one is stock in Eaches, the other is stock in weeks of supply)

When plotting the two data sets for most of my graphs (300 SKU's) there is a slight difference is the auto scaling.

How can I set up the chart so there appears to be only one line, even though both sets of data are there on top of each other perfectly?

 

[mcb7722]

I have the graph set up with dual y-axis, so the left axis is set to eaches and the right is set to weeks

 

[mcb7722]

Is there any way to set the max value of the scale on both y-axis to be 110% of the maximum value?

ex

EA y-axis = max(range of EA)*1.1
wks y-axis = max(range of wks)*1.1

 

[mcb7722]

Figured it out......

Sheets("Data Chart").Select
With ActiveChart.Axes(xlValue)
.MinimumScale = 0
.MaximumScale = value
.MinorUnitIsAuto = True
.MajorUnitIsAuto = True
End With