Lori -
You can't do this for any random values of south or east coordinates,
only for regularly spaced values, and Excel expects a Z axis value for
each combination of south and east. If you meet these criteria, set up
your data like this:
Cell A1: Blank
Cells B1, C1, etc.: East coordinates, evenly spaced
Cells A2, A3, etc.: South coordinates, evenly spaced
Cells B2, B3, C2, C3, etc.: Values
Select the range, and construct your 3D column chart (or surface or
contour chart).
If you don't meet these criteria, you'll have to investigate a different
charting package. Wanting a column chart is maybe easier. You could
set up many more east and south coordinates than you really need, and
leave blanks in the data. Where there's a blank, you will simply not
get a column in the chart. In a surface or contour chart, you get
discontinuities as the surface dives to zero.
- Jon
