3D area graph

  • Thread starter Thread starter pl.carry
  • Start date Start date
P

pl.carry

I have a 3D area graph. I can see where to put the TITLES for the 3 axis,
but where to input the VALUES for the Y axis. Values for X and X are OK.
The graph puts by itself values such as S201 for Ys which I don't know where
it gets them. The data required for Y are contiguous to the source data.
Thanks.
Pierre
 
I have a 3D area graph. I can see where to put the TITLES for the 3 axis,
but where to input the VALUES for the Y axis. Values for X and X are OK.
The graph puts by itself values such as S201 for Ys which I don't know
where
it gets them. The data required for Y are contiguous to the source data.
Thanks.
Pierre
Click to expand...

Excel doesn't support value axes on the 3D charts; only category axes. So
you can't tell Excel where to chart the x,y,z triplet; it only works for
equally spaced x and y values.

Excel has quite limited 3D charting capacity, which may also prevent you
from implementing the dynamic charting you asked about earlier.
 
Thanks Dave,
A bit disappointing really.
Altitude (z) and Longitude (x) chart nicely, the y as well and the chart is
OK, just the labels attached to the y axis are phony.
Since Excel all by itself sticks a series of labels along the Y axis I would
have thought that it should be possible to go and poke the right values
(transformed into label/text if that is the protocole) into the vector where
Excel contrives these funny labels to begin with.
All the x,y, are regularly spaced since those are from DEM, z is as erosion
allows.
Pierre

"dvt" <[email protected]> a écrit dans le message de
I have a 3D area graph. I can see where to put the TITLES for the 3 axis,
but where to input the VALUES for the Y axis. Values for X and X are OK.
The graph puts by itself values such as S201 for Ys which I don't know
where
it gets them. The data required for Y are contiguous to the source data.
Thanks.
Pierre
Click to expand...

Excel doesn't support value axes on the 3D charts; only category axes. So
you can't tell Excel where to chart the x,y,z triplet; it only works for
equally spaced x and y values.

Excel has quite limited 3D charting capacity, which may also prevent you
from implementing the dynamic charting you asked about earlier.
 
Altitude (z) and Longitude (x) chart nicely, the y as well and the chart
is
OK, just the labels attached to the y axis are phony.
Since Excel all by itself sticks a series of labels along the Y axis I
would
have thought that it should be possible to go and poke the right values
(transformed into label/text if that is the protocole) into the vector
where
Excel contrives these funny labels to begin with.
All the x,y, are regularly spaced since those are from DEM, z is as
erosion
allows.
Pierre
Click to expand...

Select the chart, go to the menu and select Chart | Source data | Series
tab. Each series has a box labeled "Name." For each series, your
corresponding y-axis label should go in that box.

For example, I have a 3d contour chart with 3 series. The first series is
named A, the second B, and the third C. On my y axis the labels A, B, and
C show up.

The x-axis labels can be dictated by the entry in the box labeled
"Category (X) axis labels" on that same dialog box.
 
The easiest way to set the ranges for a "3D" chart are to array the
labels for one axis across the top row of the data range (need not be
row 1 of the sheet), for the others down the left row of the range (nor
column A), leave the top left cell blank, and put your Z values in the
matrix below and left of the labels, like this:


Y1 Y2 Y3 Y4 Y5
X1 Z11 Z12 Z13 Z14 Z15
X2 Z21 Z22 Z23 Z24 Z25
X3 Z31 Z32 Z33 Z34 Z35
X4 Z41 Z42 Z43 Z44 Z45

etc. Now select the entire range, including the labels and the blank
top left cell, start the chart wizard, and choose one of the
Surface/Contour types. Excel automatically uses the labels the way you
intended (the blank cell is the key), and you don't need to fiddle with
the Source Data tab of the wizard.

- Jon
 
Thank you Jon,
As always your explanations are luminous.
The empty cell is indeed the key, with the contiguity of data and labels.
When I followed yr example my topographic map looked proper.
The limitation of this approach is that if you have a complete (wide) set of
Latitude/Longitude and you want to experiment with the ranges to minimize
masking effects of high elevations you will lose this contiguity. As soon as
I changed the range from line 2 (including labels to line 58 for the origin
of data) the good labels disappeared and reappeared these S1 to S121 coming
from nowhere. I guess I will have to keep a master data set, make copies and
keep deleting rows until I hit the right perspective.
I tried naively to freeze the window with the label col/lines at the border
in the hope that the freeze would serve as a note that the labels are along
the borders of the window, did not work. But it might be a better use of
Excel existing features to go look for labels on the border of frozen window
than the use of an empty cell.
Thanks again for your help.
Pierre

Jon Peltier said:
The easiest way to set the ranges for a "3D" chart are to array the
labels for one axis across the top row of the data range (need not be
row 1 of the sheet), for the others down the left row of the range (nor
column A), leave the top left cell blank, and put your Z values in the
matrix below and left of the labels, like this:


Y1 Y2 Y3 Y4 Y5
X1 Z11 Z12 Z13 Z14 Z15
X2 Z21 Z22 Z23 Z24 Z25
X3 Z31 Z32 Z33 Z34 Z35
X4 Z41 Z42 Z43 Z44 Z45

etc. Now select the entire range, including the labels and the blank
top left cell, start the chart wizard, and choose one of the
Surface/Contour types. Excel automatically uses the labels the way you
intended (the blank cell is the key), and you don't need to fiddle with
the Source Data tab of the wizard.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
Click to expand...
 
Back
Top