Jump to content
Software FX Community
nknasi

Surface chart help

Recommended Posts

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...