Microsoft Office Tutorials and References
In Depth Information
Chart Art
Figure 12-9: Creating a mountain out of an area chart
Figure 12-10: A bubble chart mouse head
The number of colors used in a surface chart depends on the Major Unit scale
value. This example includes a Spinner control (linked to cell I3) that enables you
to easily change the Major Unit value for the chart (this is done with a simple
macro). Smaller Major Unit values produce more colors. Another spinner, linked
to cell I6, feeds the formulas in the chart’s source range (A1:G7). These formulas
are color-coded to identify the cells that contain the same formula. Some of these
formulas refer to a randomly generated value, which results in a wide variety of
patterns.
Search JabSto ::




Custom Search