Microsoft Office Tutorials and References
In Depth Information
Creating your own custom chart types
T ABLE 2-14 EXCEL’S CUSTOM CHART TYPES (Continued)
Chart Type
How it Has Been Customized
Logarithmic
A line chart that uses a logarithmic scale on the
value axis
Outdoor bars
A bar chart with fill patterns that resemble wood, with
a green background
Pie explosion
A 3-D pie chart with all slices exploded, on a dark
background
Smooth lines
A line chart with smoothed lines
Stack of colors
A stacked-column chart, with a line connecting the
top of each column
Tubes
A stacked-bar chart with gradient fill to simulate
cylindrical bars
Several of the custom chart types are combination charts. A combination
chart combines two different chart types, such as a column chart and a line
chart. In such a case, each series is assigned its own chart type. A
combination chart requires that the chart types use the same category axis, but they
may use different value axes. Also, 3-D charts cannot be combined with
another chart type.
Creating your own custom chart types
This section presents a hand-on example that demonstrates how to create your own
custom chart type. After it’s created, you can select it using the Chart Wizard, and
your custom formatting will be applied instantly.
You can create as many custom chart types as you like. And you can share them
with your co-workers simply by making a copy of your xlusrgal.xls file (see the
sidebar, “Custom Chart Types: Behind the Scenes”).
Figure 2-27 shows a worksheet with the results of a customer-satisfaction
survey. The goal of this exercise is to create a custom chart type that will be used to
plot the results of each survey item.
STEP 1: CREATE A CHART
The first step is to create a chart. Every chart must have some data, so I use the first
survey item for the initial chart.
Search JabSto ::




Custom Search