Microsoft Office Tutorials and References
In Depth Information
T ABLE 2-10 SURFACE CHART SUBTYPES (Continued)
Surface (top view)
3-D surface chart as viewed from above
Surface (top view wireframe)
3-D surface chart as viewed from above; no color
Figure 2-21: A surface chart
It’s important to understand that a surface chart does not plot 3-D data
points. The series axis for a surface chart, as with all other 3-D charts, is a
category axis — not a value axis. In other words, if you have data that is
represented by x, y, and z coordinates, it cannot be plotted accurately on a surface
chart unless the x and y values are equally spaced.
Think of a bubble chart as an XY chart that can display an additional data series,
which is represented by the size of the bubbles. As with an XY chart, both axes are
value axes — there is no category axis.
Figure 2-22 shows an example of a bubble chart that depicts the results of a
weight-loss program. The horizontal value axis represents the original weight, the
vertical value axis shows the length of time in the program, and the size of the
bubbles represents the amount of weight lost.
Table 2-11 lists Excel’s two bubble chart subtypes.