nknasi Posted April 28, 2011 Report Share Posted April 28, 2011 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! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.