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:
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!
Surface chart help
in General
Posted
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!