Just wondering if its possible to plot a scatter graph with 3 axises, or if theres a plugin for it? I have Office 2007. Thanks in advance.

- Help creating 3D graphs with x, y, z
- Combine Line / Graph chart on X / Y / Z axis
- **3D Interpolation x,y,z -> f(x,y,z)**
- 3D line plot (x,y,z axis)
- Can I copy x-y scatter plot data direct from one plot to another?
- Scatter Graph X-Axis Problems
- Prediciting Values (z) from given data set (x,y,z)
- Coloring X,y,z Values
- Changing an Array to X, Y, Z.
- Analyzing X,Y,Z coordinates of a chart
- True x,y,z stacked column charts
- How do I specify X,Y axis and Series values in a line graph?
- XYZ coordinates in Excel graph 3D
- 3D Scatter Chart
- Graphs with dynamic x-y axis
- XYZ scatter graphs
- How do i do x/y axis graph
- How to calculate volume of a 3d graph
- Same X,Y values with multiply Z values
- How do I make two y axis in bar graphs (i.e. cross hatching)??
- Insert worksheet "X" "Y" & "Z"
- 3D Scatter Plot Capability
- Truncate scatter graph automatically /OR/ log x-axis and defining tick marks on Line Chart
- 3d chart with xyz axis

Thanks in advance.

Basically, I need a UDF for 3D Interpolation.

I was able to make UDF for 2D Interpolation, but 3D is very difficult.

Scenario: I will have a table with X, Y, Z and appropriate value f(x,y,z). With given table, if I pick any number to X,Y,Z , then interpolated f(x,y,z) is generated.

I attached a file! so please have a look!

My table will be either Table 1 or Table 2 or anything else. Means, Range Y wouldn't be same, Interval wouldn't be same, etc.

Thank you in advance!

Chris

P.S

.pdf file might help you understanding mathematical concepts.

I have a set of data points (x,y,z) that I would like plotted either as different lines or different columns/cylinders. For instance, at the x,y location, a column/line with height z. The red arrows in the attached image shows sort of what I'm looking for, except I want it around a circle, not square.

I tried using the 3D line, 3D column & 3d cylinder, but it's not very flexible when working with a 3rd axis. Is this possible, or would I have to resort to another language?

I can successfully plot a plane with the 3 coordinates and that's almost what I'm looking for. It would be easier to visualize it with bars going from z=0 to z=some number. It works really well in Matlab .

scatter plot. I have several plots containing data each representing a small

map. I would like to add one of those plots (maps) to an existing plot (map)

without individually creating a set of new series and adding each one, one at

a time, to the plot.

I would prefer to somehow simply copy and past the plot or somehow reference

the plot to be added but can find no commands to allow me to do this.

Thank you for you time.

I have the following "known" data (x,y,z) which I am able to plot a bubble

chart from. However I want to be able to predicit the "z" value given new x

and y values based on a trend- is this possible in excel? (trend lines seem

to only be linear i.e. between x and y)- or any idea how I can do this?

Data Set (x,y,z):

96.0%, 95.3%, 2.911

94.4%, 98.0%, 2.297

96.3%, 93.8%, 2.631

96.9%, 93.2%, 4.697

97.1%, 95.3%, 1.073

96.4%, 99.2%, 0.808

96.3%, 94.0%, 1.292

96.7%, 97.1%, 1.414

97.1%, 96.0%, 1.153

I would like to predict the z values for:

91.0%, 83.0%

87.0%, 83.0%

98.0%, 96.0%

90.0%, 95.0%

98.0%, 99.0%

98.0%, 96.0%

98.0%, 97.0%

Thanks

first, use rnd() fxn

second, sort x,y,z each and use rank() fxn.

third, coloring

how to color x,y,z axes with sorted x,y,z values.

thanks in advance,

Thanks for your help,

be able to sort the list by proximity to each other. Is there a way to

convert the coordinates into a single number so that I can sort on that

number?

Maybe this is more a math question than an excel question, but I'd

appreciate any help.

geodude

well as specifying the values for the lines/series information.

Currently all I can do is specify either both x & y axis via a scatter Graph

or one axis and the Series values via a line Graph.

Any suggestions?

X Axis - Years (2004, 2005 ,...)

Y Axis - Quantity (imported, exported, produaced)

Z- Axiz - Name of the products

I want to make a graph with teh X, y,z axis in excel. When i use the 3D graphs in excel, it is not taking the z vales connected to teh cell. Anybody can help me pllllllll

axes) using excel? Is this possible?

can I have dynamic charts that allow me to change the values for the x-y

coordinates?

E.g. if I have a histogram of names along the bottom, and ages on the y

axis, can I then choose from a drop down list whether to show e.g all names

from the spread sheet or just names beginning with 'A' or whatever? i.e sort

of like a pivot table but in graph form

thanks very much for any help

cheers

barbara

I realise Excel cannot do XYZ scatter graphs, but am sure there is a solution to my problem (be it surface graphs or something like that)... Can anyone help me display this data across 3 axis?

x y z

50% -10% 529

50% -5% 625

50% 0% 721

50% 5% 1273

50% 10% 1390

50% 15% 1508

50% 20% 1625

50% 25% 1743

100% -10% 455

100% -5% 547

100% 0% 639

100% 5% 1178

100% 10% 1291

100% 15% 1404

100% 20% 1517

100% 25% 1630

150% -10% 381

150% -5% 469

150% 0% 557

150% 5% 1083

150% 10% 1192

150% 15% 1300

150% 20% 1409

150% 25% 1517

information not numerical values, how do i do that any ideas?

tks very much

Is this possible to do? I'm thinking maybe using trapezoid rule but in 3D...

Thanks

I want to add new worksheets into a workbook. The name of the new sheets should be "x" "y" and "z".

How to make it?

Thanks in advance.

Gabor

It also happens to be a very large data set (16,200 triplets or 48,600 numbers) but if that were a problem, it could be separately addressed.

I am trying to display a series of variables along an exponential x-axis (frequency x amplitude). I have encountered a problem in both methods using Excel 2007.

1. Scatter Graph

On the scatter graph I can make the x-axis exponential and everything looks great (including tick marks) but there is a big space between the start of the axis and the first frequency/dB point as well as the last marker point and the end of the x-axis. I understand that I can make a minimum and a maximum in the axis options but because the values change I want it to truncate automatically and keep or pre-define tick marks at say log 100, 1000, 10000 ; 200, 2000, 20000 ; or maybe in Octave bands.

2. Line Chart

On the Line Chart, the graph truncates perfectly, but the x-axis can not be set to logarithmic scale and the tick marks are displayed as increasing numbers related to the random start point of the series eg: if the first data point is 158Hz the x-axis ticks go up at a certain rate according to that number.

My questions: Is there a way to set tick marks, which will correspond to whatever data is being used for the graph? Tick marks which stay as they are set.

Is it possible to do a 3d chart showing scale for x, y & z axis in excel, I can only get it to scale x and y.

eg

x = 10

y = 5

z = 10

Thanks in advance for your assistance.

No luck finding an answer? You could always try Google.