Excel Surface Graph not plotting correctly (or at least I dont think it is)

On a surface graph in Excel my information is being displayed with empty values between major tick markers. For example (as shown in the image below) if I have a series of data in values reading 1, 2, 3, 4, 5, 6, 7, 8, 9 and 500 (ie. without 10-499 included in the data) then the graph will completely leave out 10-499 and act like that there is no gap between 9 and 500. How can I fix this? Is there a way to make Excel automatically realize that there is 490 points between those two numbers and reflect that in the plotted graph?

Many thanks,
~Frab

Capture.PNG

Originally Posted by MrShorty

Excel cannot do (using its built in functionality) a proper 3D scatter/surface chart. Excel's surface charts can only treat the X (category) and Y (series) as text/category data and cannot treat them as numeric. Depending on exactly what you are trying to do you can:

A) Use a more robust 3rd party charting application that has more robust 3D scatter/surface charting options. If this is something you will need to do frequently and with varying inputs and such, this might be the easiest and best solution long term.
B) You can include rows/categories for 10 to 499, then figure out how Excel is going to treat the blanks entries and see if you need to do something more (interpolate maybe) to get the right rendering of those points.

Many thanks MrShorty. I was worried that might be the case.

~Frab