Tuesday, 20 August 2013

Excel 2003 XYZ Surface Chart like XY Line Chart

Excel 2003 XYZ Surface Chart like XY Line Chart

I have a grid of of values in Excel 2003 that form a surface.
Simplified example
Day 1 2 3 5
==================
1 0 0 2 1
2 0 2 3 0
3 0 0 1 0
in the column headings 4 is missing because there are no entries for 4
(i.e. all data is zero)
When I come to try and plot this as a surface chart in Excel 2003 it plots
1,2,3,5 as though they were series names and the same distance apart which
distorts the surface (i.e. treats them as a category axis not a value
axis)
Is there anyway to get excel to produce what amounts to an xyz value axis
surface chart?
In the real data its not feasible to fill in the missing column numbers.

No comments:

Post a Comment