Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
create a chart using two columns for x & y, third for line data
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 |
#3
|
|||
|
|||
create a chart using two columns for x & y, third for line dat
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
Setting up data to create a chart | Excel Worksheet Functions |