Microsoft Office Tutorials and References
In Depth Information
SIMULATING A "BROKEN" VALUE AXIS
I removed the walls from all charts, and only the frontmost chart has a value
axis. The title, legend, and year labels are text boxes that I added separately. When
you’re combining charts like this, it’s very important that the value axes use
identical scaling. Also, any modification to the 3-D view (for example, rotation) must be
applied to all the charts.
SIMULATING A “BROKEN” VALUE AXIS
The final example, in Figure 8-60, shows a standard column chart, along with
another chart that simulates a “broken” value axis. This type of chart is often used
when a few data points greatly exceed the others. In the example, the value for
June is much larger than the other values. When plotted on a standard chart, the
other values are dwarfed.
Figure 8-60: Two charts are combined to
simulate a broken axis.
The chart on the right consists of two charts, shown in Figure 8-61. Both charts
use the same data but different value axis scaling. The main chart (on the left)
contains the title and lots of white space above the Plot Area. The value axis Maximum
is set to 1,000. The secondary chart has a transparent Chart Area with no border,
and its value axis ranges from 4,500 to 5,000. An AutoShape is used to indicate the
fact that the column is not continuous.