Microsoft Office Tutorials and References
In Depth Information
Varying column widths
5. Change the chart type of the new series to an XY chart with the data
points connected by lines.
6. Adjust the secondary Y axis. The default Minimum and Maximum values are
1 and 12, respectively. Change these to 0.5 (Minimum) and 12.5 (Maximum).
This change makes the line begin at the midpoint of the Jan bar and end at
the midpoint of the Dec bar.
7. If you prefer that the months begin at the top of the chart, select the Category
axis (on the left) and access the Format Axis dialog box. Select Categories in
Reverse Order, and Value (Y) Axis Crosses at Maximum category.
8. Repeat Step 7 for the Secondary Value axis on the right side of the chart.
Figure 8-22: A bar-line combination chart is possible if you create the line with
an XY series.
Varying column widths
The column chart shown in Figure 8-23 is a bit unusual: The width of the columns is
not the same! The chart displays the Units Sold data on the value axis, and the width
of each column is proportional to the Total Income for the product. In other words,
this column chart is conveying more information than a typical column chart.
Although you can control the width of all columns by using the gap width
setting, Excel does not provide an option to vary the width of individual columns. This
chart is not actually using the data in A1:D7. Rather, the chart consists of six series,
each with 100 data points. A portion of the data is shown in Figure 8-24.
The cells in column J contain formulas that determine the number of columns to
show for each of the six series, using the values in column D (Total Income).
Remember, this chart contains 100 data points. These data points are allocated
among the six series. Formulas in columns K:L determine the starting row and the
ending row for the data in each series. For example, Series A will display 12 of the
Search JabSto ::

Custom Search