Plotting with 3 columns data (X,Y and Values)

[gundalav]

Hi all,

I have the following data, which I want to plot with Excel chart:

x y value
1 1 0.191850392857143
1 2 0.343870875
1 3 0.373216464285714
1 4 0.439175392857143
2 1 0.0218835357142857
2 2 0.136193589285714
2 3 0.146259946428571
2 4 0.181633303571429
...... can be more ....

How can I plot the data (scatter) where the x-axis correspond
to "x" column and y-axis correspond to "y" column.

As you can see the data comes from a loop of x array from (1 to 2)
over y array from (1 to 4). Which in the ends forms 2x4 matrix.

Regards,
Gundala Viswanath
Jakarta-Indonesia

 

[Mike Middleton]

gundalav -

Excel cannot plot 3D data as a scatter chart. Your alternatives are a 3D
Column chart type or a Surface chart type. See online Help for "Creating a
surface chart."

For either chart type, the X and Y axes use equally-spaced category labels.
Only the Z axis is numerical. Since your X and Y values are equally-spaced,
the results will not be distorted.

The data must be arranged with the X labels in a column on the left, Y
labels in a row across the top, Z values in the body of the table, and
preferably an empty (Clear Contents) cell in the top left corner. Select the
entire range, and create the chart.

To arrange the data, you could retype, or you could use a pivot table.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel