create a chart using two columns for x & y, third for line data

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

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

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
>
>

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
>>
>>