Microsoft Office Tutorials and References
In Depth Information
Replacing Columns with Arrows
6. From the Format tab, select Shape Fill, Black.
7. On the Layout tab, turn off the legend and the gridlines.
8. Type a title, as shown in Figure 3.26, pressing Enter after the first line of the title. On
the Home tab, change the title font size to 14 point, left aligned.
9. Right-click the numbers along the vertical axis and select Format Axis. Change Major
Unit to Fixed, 500.
The result is a chart that calls attention to Friday sales.
Replacing Columns with Arrows
Columns shaped like arrows can be used to make a special point. For example, if you have
good news to report about consistent growth, you might want to replace the columns in the
chart with arrow shapes to further indicate the positive growth.
Follow these steps to convert columns to arrows:
1. Create a column chart showing a single series.
2. In an empty section of the worksheet, insert a new block arrow shape. From the Insert
tab, select Shapes, Blck Arrows, Up Arrow. Click and drag in the worksheet to draw
the arrow.
3. Select the arrow. Press Ctrl+C to copy the arrow to the Clipboard.
4. Select the chart. Click a column to select all the columns in the data series.
5. Press Ctrl+V to paste the arrow. Excel fills the columns with a picture of the block
6. If desired, select Format Selection from the Format tab. Reduce the gap setting from
150 percent to 75 percent to make the arrows wider.
The new chart is shown in the bottom half of Figure 3.27. After creating the chart, you can
delete the arrow created in step 2 by clicking the arrow and pressing the Delete key.
Highlighting a Section of Chart by Adding a Second Series
The chart in Figure 3.28 shows a sales trend over one year. The business was affected by
road construction that diverted traffic flow from the main road in front of the business.
The title calls out the July and August time period, but it would be helpful to actually
highlight that section of the chart. Follow these steps to add an area chart series to the chart:
1. Begin a new series in Column C, next to the original data. To highlight July and
August, add numbers to Column C for the July and August points, plus the previous
point, June. In cell C7, enter the formula of =B7 . Copy this formula to July and August.
2. Click on a blank area inside of the chart. A blue bounding box appears around B2:B13
in the worksheet. Drag the lower-right corner of the blue bounding box to the right to
Search JabSto ::

Custom Search