Steema Central

Steema Software - Customer Support Forums
http://216.92.243.79/support/

Axis Scaling Problems

http://216.92.243.79/support/viewtopic.php?f=1&t=5339

Page 1 of 1

Axis Scaling Problems

Posted: Wed Dec 20, 2006 3:05 pm
by 9531181
Hi
I have a problem in axis scaling, when i use the following data

Private Sub Form_Load()
With TChart1
.AddSeries scLine
.Series(0).AddXY 288.904, 0.000104441, "", vbRed
.Series(0).AddXY 293.004, 0.000105175, "", vbRed
.Series(0).AddXY 297.129, 0.000105942, "", vbRed
.Series(0).AddXY 301.251, 0.000106739, "", vbRed
.Series(0).AddXY 305.371, 0.000107568, "", vbRed
.Series(0).AddXY 309.49, 0.00010843, "", vbRed
.Series(0).AddXY 313.606, 0.000109328, "", vbRed
.Series(0).AddXY 317.72, 0.000110264, "", vbRed
.Series(0).AddXY 321.832, 0.000111242, "", vbRed
.Series(0).AddXY 325.942, 0.000112262, "", vbRed
.Series(0).AddXY 330.05, 0.000113329, "", vbRed
.Series(0).AddXY 334.157, 0.000114447, "", vbRed
.Series(0).AddXY 338.261, 0.000115618, "", vbRed
.Series(0).AddXY 342.364, 0.000116847, "", vbRed
.Series(0).AddXY 346.465, 0.000118139, "", vbRed
.Series(0).AddXY 350.564, 0.000119498, "", vbRed
.Series(0).AddXY 354.661, 0.000120931, "", vbRed
.Series(0).AddXY 358.757, 0.000122444, "", vbRed
.Series(0).AddXY 362.851, 0.000124045, "", vbRed
.Series(0).AddXY 366.944, 0.000125741, "", vbRed
.Series(0).AddXY 371.035, 0.000127542, "", vbRed
.Series(0).AddXY 375.125, 0.00012946, "", vbRed
.Series(0).AddXY 379.213, 0.000131506, "", vbRed
.Series(0).AddXY 383.3, 0.000133695, "", vbRed
.Series(0).AddXY 387.385, 0.000136045, "", vbRed
.Series(0).AddXY 391.469, 0.000138576, "", vbRed
.Series(0).AddXY 395.552, 0.000141311, "", vbRed
.Series(0).AddXY 399.634, 0.000144281, "", vbRed
.Series(0).AddXY 403.715, 0.000147519, "", vbRed
.Series(0).AddXY 407.795, 0.00015107, "", vbRed
.Series(0).AddXY 411.874, 0.000154989, "", vbRed
.Series(0).AddXY 415.953, 0.000159346, "", vbRed
.Series(0).AddXY 420.032, 0.000164232, "", vbRed
.Series(0).AddXY 424.11, 0.000169772, "", vbRed
.Series(0).AddXY 428.189, 0.000176137, "", vbRed
.Series(0).AddXY 432.27, 0.000183577, "", vbRed
.Series(0).AddXY 436.354, 0.000192479, "", vbRed
.Series(0).AddXY 440.443, 0.000203489, "", vbRed
.Series(0).AddXY 444.544, 0.000217837, "", vbRed
.Series(0).AddXY 448.674, 0.000238458, "", vbRed
.Series(0).AddXY 452.927, 0.000278151, "", vbRed
.Series(0).AddXY 454.087, 0.000303528, "", vbRed
.Series(0).AddXY 454.499, 0.000330204, "", vbRed
.Series(0).AddXY 452.653, 0.000420412, "", vbRed
.Series(0).AddXY 450.382, 0.000474714, "", vbRed
.Series(0).AddXY 449.37, 0.000496302, "", vbRed
.Series(0).AddXY 447.369, 0.000537011, "", vbRed
.Series(0).AddXY 443.383, 0.000614953, "", vbRed
.Series(0).AddXY 439.436, 0.000692135, "", vbRed
.Series(0).AddXY 435.507, 0.000771288, "", vbRed
.Series(0).AddXY 431.587, 0.000853936, "", vbRed
.Series(0).AddXY 427.674, 0.000941162, "", vbRed
.Series(0).AddXY 423.765, 0.00103388, "", vbRed
.Series(0).AddXY 419.86, 0.00113297, "", vbRed
.Series(0).AddXY 415.958, 0.00123929, "", vbRed
.Series(0).AddXY 412.059, 0.00135377, "", vbRed
.Series(0).AddXY 408.162, 0.0014774, "", vbRed
.Series(0).AddXY 404.268, 0.00161124, "", vbRed
.Series(0).AddXY 400.375, 0.0017565, "", vbRed
.Series(0).AddXY 396.485, 0.00191451, "", vbRed
.Series(0).AddXY 392.597, 0.00208675, "", vbRed
.Series(0).AddXY 388.711, 0.00227489, "", vbRed
.Series(0).AddXY 384.826, 0.00248084, "", vbRed
.Series(0).AddXY 380.944, 0.00270674, "", vbRed
.Series(0).AddXY 377.064, 0.00295504, "", vbRed
.Series(0).AddXY 373.186, 0.00322853, "", vbRed
.Series(0).AddXY 369.309, 0.00353039, "", vbRed
.Series(0).AddXY 365.435, 0.00386431, "", vbRed
.Series(0).AddXY 361.562, 0.00423448, "", vbRed
.Series(0).AddXY 357.692, 0.00464578, "", vbRed
.Series(0).AddXY 353.824, 0.00510384, "", vbRed
.Series(0).AddXY 349.957, 0.00561521, "", vbRed
.Series(0).AddXY 346.093, 0.00618751, "", vbRed
.Series(0).AddXY 342.231, 0.00682963, "", vbRed
.Series(0).AddXY 338.37, 0.00755199, "", vbRed
.Series(0).AddXY 334.512, 0.00836687, "", vbRed
.Series(0).AddXY 330.656, 0.00928872, "", vbRed
.Series(0).AddXY 326.803, 0.0103347, "", vbRed
.Series(0).AddXY 322.951, 0.0115251, "", vbRed
.Series(0).AddXY 319.101, 0.0128842, "", vbRed
.Series(0).AddXY 315.254, 0.014441, "", vbRed
.Series(0).AddXY 311.409, 0.0162306, "", vbRed
.Series(0).AddXY 307.567, 0.018295, "", vbRed
.Series(0).AddXY 303.726, 0.0206854, "", vbRed
.Series(0).AddXY 299.888, 0.023464, "", vbRed
.Series(0).AddXY 296.053, 0.0267069, "", vbRed
.Series(0).AddXY 292.219, 0.0305079, "", vbRed
.Series(0).AddXY 288.389, 0.0349825, "", vbRed
.Series(0).AddXY 284.56, 0.0402745, "", vbRed
.Series(0).AddXY 280.734, 0.0465634, "", vbRed
.Series(0).AddXY 276.911, 0.0540744, "", vbRed
.Series(0).AddXY 273.09, 0.0630923, "", vbRed
.Series(0).AddXY 269.272, 0.0739788, "", vbRed
.Series(0).AddXY 265.456, 0.0871967, "", vbRed
.Series(0).AddXY 261.643, 0.10334, "", vbRed
.Series(0).AddXY 257.833, 0.12319, "", vbRed
.Series(0).AddXY 254.026, 0.14774, "", vbRed
.Series(0).AddXY 250.221, 0.17833, "", vbRed
.Series(0).AddXY 246.419, 0.21671, "", vbRed
.Series(0).AddXY 242.62, 0.26525, "", vbRed
.Series(0).AddXY 238.823, 0.3271, "", vbRed
.Series(0).AddXY 235.03, 0.40659, "", vbRed
.Series(0).AddXY 231.24, 0.50964, "", vbRed
.Series(0).AddXY 227.452, 0.64449, "", vbRed
.Series(0).AddXY 223.668, 0.82264, "", vbRed
.Series(0).AddXY 219.887, 1.0604, "", vbRed
.Series(0).AddXY 216.109, 1.3812, "", vbRed
.Series(0).AddXY 212.335, 1.819, "", vbRed
.Series(0).AddXY 208.564, 2.4234, "", vbRed
.Series(0).AddXY 204.796, 3.2687, "", vbRed
.Series(0).AddXY 201.032, 4.4664, "", vbRed
.Series(0).AddXY 197.272, 6.1878, "", vbRed
.Series(0).AddXY 193.515, 8.6986, "", vbRed
.Series(0).AddXY 189.763, 12.419, "", vbRed
.Series(0).AddXY 186.014, 18.025, "", vbRed
.Series(0).AddXY 182.27, 26.623, "", vbRed
.Series(0).AddXY 178.53, 40.06, "", vbRed
.Series(0).AddXY 174.795, 61.483, "", vbRed
.Series(0).AddXY 171.064, 96.374, "", vbRed
.Series(0).AddXY 167.338, 154.5, "", vbRed
.Series(0).AddXY 163.617, 253.71, "", vbRed
.Series(0).AddXY 159.901, 427.48, "", vbRed
.Series(0).AddXY 156.191, 740.36, "", vbRed
.Series(0).AddXY 152.487, 1320.6, "", vbRed
.Series(0).AddXY 148.788, 2431.6, "", vbRed
.Series(0).AddXY 145.096, 4632.2, "", vbRed
.Series(0).AddXY 141.41, 9154.4, "", vbRed
.Series(0).AddXY 137.731, 18822, "", vbRed
.Series(0).AddXY 134.059, 40390, "", vbRed
.Series(0).AddXY 130.395, 90781, "", vbRed
.Series(0).AddXY 126.738, 214550, "", vbRed
.Series(0).AddXY 123.09, 535501, "", vbRed
.Series(0).AddXY 119.45, 1418390, "", vbRed
.Series(0).AddXY 115.819, 4008550, "", vbRed
.Series(0).AddXY 112.198, 12161100, "", vbRed
.Series(0).AddXY 108.587, 39876300, "", vbRed
.Series(0).AddXY 104.987, 142415000, "", vbRed
.Series(0).AddXY 101.398, 558823000, "", vbRed
.Series(0).AddXY 97.821, 2433130000#, "", vbRed
.Series(0).AddXY 94.256, 11888300000#, "", vbRed
.Series(0).AddXY 90.705, 66028300000#, "", vbRed
.Series(0).AddXY 87.169, 423081000000#, "", vbRed
.Series(0).AddXY 83.648, 3181370000000#, "", vbRed
.Series(0).AddXY 80.143, 28634600000000#, "", vbRed
.Series(0).AddXY 76.655, 315688000000000#, "", vbRed
.Series(0).AddXY 73.187, 4.37953E+15, "", vbRed
.Series(0).AddXY 69.738, 7.89198E+16, "", vbRed
.Series(0).AddXY 66.311, 1.91804E+18, "", vbRed
.Series(0).AddXY 62.907, 6.57498E+19, "", vbRed
.Series(0).AddXY 59.529, 3.3546E+21, "", vbRed
.Series(0).AddXY 56.178, 2.71837E+23, "", vbRed
.Series(0).AddXY 52.856, 3.78678E+25, "", vbRed
.Series(0).AddXY 49.566, 9.99453E+27, "", vbRed
.Series(0).AddXY 46.312, 5.63859E+30, "", vbRed
.Series(0).AddXY 46.081, 8.45689E+33, "", vbRed
.Series(0).AddXY 46.081, 0, "", vbRed
.Series(0).AddXY 46.081, 0, "", vbRed

.Aspect.View3D = False
End With

End Sub


some values are very small and some are very much larger so we don't show anything.Could you please tell us how to solve this problem so that we are able to show proper graph(i.e. the graph should be within the range).

Thanks & Regards

Posted: Wed Dec 20, 2006 3:34 pm
by narcis
Hi Faizullah,

You can try setting axes offset like this:

Code: Select all

        .Axis.Bottom.MinimumOffset = 5
        .Axis.Bottom.MaximumOffset = 5
        .Axis.Left.MinimumOffset = 5
        .Axis.Left.MaximumOffset = 5

Axis Scaling problem has been solved

Posted: Tue Dec 26, 2006 7:54 am
by 9531181
Excellent, That works.

Thanks Narcis
All times are UTC
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/