View Single Post
  #4   Report Post  
Jon Peltier
 
Posts: n/a
Default create a chart using two columns for x & y, third for line dat

Oh, now I get it. I misread your ascii art.

Excel doesn't have a native capability to create 3D xyz charts.

Andy Pope demonstrates a workaround on his web site:

http://andypope.info/charts/3drotate.htm

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

Ted K wrote:

Thnaks Jon,

I would like to construct a line chart using the z column data as the data
points for this line.

"Jon Peltier" wrote:


What do you mean, "line data"?

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

Ted K wrote:


Need help creating a chart using x data for x axis, y for y axis and z for
line data. The data follows:

x y z
6.070 1.470 0.242
9.010 2.058 0.228
10.970 2.380 0.230
11.950 2.580 0.216

A example chart:
| z
| z
x| z
| z
|___________________
Y

TIA

Ted