Excell VBA value axis(y) scale manipulation 1

[DataHugger]

I wish to limit the number of values that appear on the side of the scale to three. I have seen many differnt ways to alter the value of a scale using VBA but I have found no way to limit the number of values that display.

Problem Description:
I have create a function that dynamically creates chart based on what worksheet in the workbook it is accessing.
I create four charts per worksheet. I am useing a function that selects different parts of the table and and generates a graph. I have now formated all the chart the way I want except for the scale. I want the automax displayed and two values inbetween 0 and the max to be displayed.

Does anyone know how to limit the value axis in this way?

Thanks again in advance.

-DataHugger

sorry if my quesiont was spastic.

 

[SkipVought]

DataHugger,

Please post a sample of your data, the type of chart you are generating and the exact results you expect to be displayed.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[SkipVought]

Just offhand I'd say that the on the Value Axis scale

    With ActiveChart.Axes(xlValue)
        .MinimumScale = MinVal
        .MaximumScale = MaxVal
        .MajorUnit = (MaxVal - MinVal)/2
    End With

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[DataHugger]

Thank you both. This is my final code snippet.
I put minimum scale in there incase somebody wants to use it for a more robust purpose.

     With ActiveChart.Axes(xlValue)
        .MaximumScaleIsAuto = True
        .MinimumScale = 0
        .MajorUnit = (.MaximumScale - .MinimumScale) / 3
    End With

I would have never known that I could use axes properties as variables. Thanks alot.

-DataHugger

 

[SkipVought]

I'm glad we BOTH could help. I assure you that I consulted with him at length. He ALSO send his appreciation.

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}

 

[DataHugger]

OOPS. I was hoping you didn't catch that.



DataHugger learned his lesson and has started to preview his posts before he submits them.

 

[SkipVought]

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}