Excel 2008 : Scaling Charts in Excel

[RyanMaurer]

In my XY scatter charts I am drawing an object. However, because of Excels auto-scaling, they often come out deformed. Is there anyway that I can lock the scales, or is there anyway that I can tell the scaling to not go past a certain point (ie, If i plot a point at 10,1 and 10,-1 then the x axis doesnt go past 10, and the y stays between 1 and -1)...

Thanks, this could ruin my project if I dont figure it out.

Ryan

[jeffreybrown]

Hello Ryan & Welcome to the Forum,

Without seeing your sample, did you try to manually set the axis instead of letting Excel guess at what you want?

Right click axis >> Format axis

If this doesn't do it, do you have a sample you can post...

[RyanMaurer]

Heres the project,

Basically Im calculating the trajectory of a model rocket, the chart in question is 2D Ballistic (source data, "Details" AL13:AK130) I want the scales to be the same, so the trajectory is represented on the graph the same as it would be in real life. Obviously the scale is dependedent on the altitude and distance flown by the rocket, however those values change based on the inputs of the user on "Rocket Info".

Im stuck lol.

[Andy Pope]

The auto scaling is based on your plotted data. It will normally extend the min/max values to encompass the min/max value in the data.

If using auto scaling or fixed values is not suitable then you will need to use code to determine what you want the min/max values to be and apply those via VBA code.

[RyanMaurer]

I have very very limited experience with vba, some experience with VB.net

How would I go about programming these charts?

[shg]

See http://www.andypope.info/charts/SetSquareAxis.htm

[Andy Pope]

Please Login or Register  to view this content.

I used the following formula in AL2:AM3

AL2: =FLOOR(MIN(AL13:AL130),10)
AM2: =FLOOR(MIN(AM13:AM130),10)
AL3: =CEILING(MAX(AL13:AL130),10)
AM3: =CEILING(MAX(AM13:AM130),10)

[RyanMaurer]

Thanks Andy!