Microsoft Office Tutorials and References
In Depth Information
USING A PICTURE IN A CHART'S PLOT AREA OR CHART AREA
To replace bars or columns with a transparent shape:
1. Add a rectangle AutoShape to the worksheet.
2. Double-click the AutoShape and select the Colors and Lines tab in the
Format AutoShape dialog box.
3. Select a Fill Color and specify a Transparent setting (the example chart
uses 75%). For best results, set the Line Color to No Line. Click OK to close
the Format AutoShape dialog box.
4. Select the AutoShape, press Shift, and choose Edit
Copy Picture. Accept
the default settings in the Copy Picture dialog box.
5. Select the bar or column series in your chart and choose Edit
6. If you like, you can then add a border around the bars or columns by
using the Patterns tab of the Format Data Series dialog box.
Chapter 16 contains a VBA macro that simplifies the processes of making bars
or columns semitransparent.
USING A PICTURE IN A CHART’S PLOT AREA OR CHART AREA
Every chart has two background elements: the Plot Area and the Chart Area. By
default, these areas display a single fill color. You can, however, insert a graphic
image for visual appeal.
To add a graphics image to a chart’s plot area or chart area, the image must
be in a file. It is not possible to copy an image and paste it to either of these
areas. To use an AutoShape in a chart’s plot area or chart area, you must first
save the AutoShape to a file (see the sidebar “Saving an AutoShape to a File”).
To add a graphic image, select either the plot area or the chart area of your chart.
Display the Format dialog box for the element and click the Patterns tab. Then click
the Fill Effects button. Click the Picture tab in the Fill Effects dialog box, and click
Select Picture to choose the file that contains the image.
Figure 6-22 shows a pie chart that uses a clip art image in its chart area.
Charts that have been customized using an image for the plot area or chart
area can be saved as a user-defined custom format. See Chapter 4 for more
information about user-defined chart formats.