Chart scales displaying same intervals on second/first Y axis

[munkee]

As you can see from the above I have created a pareto analysis graph. The problem is the left hand axis is showing the same intervals as the right hand. This of course is producing double values to be shown.

How do I get the left hand side axis to auto scale instead of following that of the same intervals as the right?

I have already messed around with the axis code but I cant seem to get this part right.

Current code I am using:

Me.grpPareto1.SetFocus
Me.grpPareto1.Object.Application.Chart.Axes(xlValue, xlPrimary).TickLabels.NumberFormat = "0"
Me.grpPareto1.Object.Application.Chart.Axes(xlValue, xlPrimary).MinorUnitIsAuto = True
Me.grpPareto1.Object.Application.Chart.Axes(xlValue, xlPrimary).MajorUnitIsAuto = True

Thanks for any help.

Chris

[munkee]

Sigh... Number format 0.0 ... ftw it was displaying wrong because they are infact 0.5 1 1.5 2 2.5 etc.. and I forced it to only show 0 1 1 2 2. I need to sleep :D

[NeoPa]

You're not talking about left and right at all are you? You're talking about the values showing on the left side doubling up and appearing to be the same at two different levels.

You need to sleep :D

(On the plus side you answered another one of your own questions.)

[munkee]

Haha yea, tiredness is definitely kicking in but I have a deadline to meet =]. What makes this all worse is I sit there for a hour trying to work it out, as soon as I come on to ask for help I see the answer 10 minutes later.

Case Closed

[NeoPa]

It's often the way. The discipline of formulating the question clearly enough is generally enough to get you thinking along the right lines.

That's another reason why asking the question clearly is so important. It often triggers the answer in the head of the questionner. Well done anyway - AND GET SOME SLEEP!