Surface Chart Help
 

Hi, I'm stuck with a surface chart that I am trying to create. I did it
successfully before with similar data, but I forgot how I did it.

I have three columns; date, byte, and latency. Each date has 20 rows
corresponding with it: one row for each byte 1-20, which in turn has a
latency value. Like this:
D1 B1.1 L1.1
B1.2 L1.2
B1.3 L1.3
D2 B2.1 L2.1
B2.2 L2.2

And so on. I want the dates on the y-axis, the byte numbers (which get
repeated every date) on the x-axis, and the latency values to have different
colored surfaces depending on the range of the value (one color for 7-8, one
for 8-9, etc.). As I said, I have done this before, so I know it's possible,
I just forgot how.

Thanks in advance for your help!

Alan -

Here's an article I wrote on surface and contour charts:

http://pubs.logicalexpressions.com/P...cle.asp?ID=447

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Alan Smith wrote:
Hi, I'm stuck with a surface chart that I am trying to create. I did it
successfully before with similar data, but I forgot how I did it.

I have three columns; date, byte, and latency. Each date has 20 rows
corresponding with it: one row for each byte 1-20, which in turn has a
latency value. Like this:
D1 B1.1 L1.1
B1.2 L1.2
B1.3 L1.3
D2 B2.1 L2.1
B2.2 L2.2

And so on. I want the dates on the y-axis, the byte numbers (which get
repeated every date) on the x-axis, and the latency values to have different
colored surfaces depending on the range of the value (one color for 7-8, one
for 8-9, etc.). As I said, I have done this before, so I know it's possible,
I just forgot how.

Thanks in advance for your help!