Jump to content
Software FX Community
nknasi

Surface chart help

Recommended Posts

nknasi    0

I am attempting to draw a surface chart where the x-axis increments by varying degrees. I am able to set the minimum value of this axis by using the Chart.axis(2).Min property. The data I am passing into the chart only has valid y-axis values for certain points on the x-axis. Here is an example dataset that my stored procedure generates:

25   85   -1.2239199999719927   85   -1.2292959999293129   85   -1.2436480000615131       85   -1.2529680000618133   85   -1.2534800000488835   85   -1.2454239999875437   85   -1.2289039999246639   85   -1.2045040000230141   85   -1.1703040000051343   85   -1.1295280000194945   85   -1.0800640000030447   85   -1.0225039999932149   85   -0.9571599999442751   85   -0.88552800007164553   85   -0.80568000003695555   85   -0.72489599995315125   35   -1.5745279999449827   35   -1.5684240000322529   35   -1.5557280000299231   35   -1.5340560000389833   35   -1.501711999997535   35   -1.4593439999967837   35   -1.4107599999755639   35   -1.3504799999296741   35   -1.280896000005343   35   -1.2012000000104345   35   -1.1079679999500547   35   -1.0125280000269449   35   -0.93352799993008451   35   -0.84490399993956153   35   -0.72933600004762455   35   -0.60220800004899525   -10   -1.7587999999523227   -10   -1.7373919999226929   -10   -1.7062240000814231   -10   -1.6646239999681733   -10   -1.6146880000829735   -10   -1.5618160000070937   -10   -1.4991119999438539   -10   -1.4038240000605641   -10   -1.3089360000565643   -10   -1.2143440000712945   -10   -1.14024800006347   -10   -1.0467679999768749   -10   -0.92974399998784151   -10   -0.79987199995666753   -10   -0.65917600002139855   -10   -0.5137439999729425   -40   -1.8161679999902827   -40   -1.7828479999676329   -40   -1.7404160000383931   -40   -1.6891519999131633   -40   -1.6275599999353335   -40   -1.5551920000463737   -40   -1.472856000065839   -40   -1.3789039999246641   -40   -1.2834720000624743   -40   -1.2106720000505445   -40   -1.1139839999377747   -40   -0.99399999994784649   -40   -0.86408799998462251   -40   -0.72515999991446753   -40   -0.57752000000327855   -40   -0.423568000085652

With respect to my graph, the first column above represents the x-axis, the second the z-axis and the third the y-axis.

When graphing the data using Chart.value(z, x) = rs.Fields("y").value

there seems to be no way to conditionally graph certain data points on the x-axis. You can only specify the number of series and number of points per series, with no way of specifying that the points are not sequential in value.

I have attempted to create data points for each distinct value on the x-axis (from 25 to 55) but this causes my graph to draw empty values for all the x-axis points that have no corresponding data in my database. If anyone knows how to adjust the step size of the x-axis of this graph I would be very appreciative. Thanks!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×