There are many ways to enhance a chart's default setting, but using custom markers is one of the easiest. You can use clip art or shapes. You can even go to the trouble to create your own graphic. If you can copy it to the Clipboard you can (probably) use it as a marker. The following Excel chart is informative, in a boring sort of way, so let's add a bit of visual interest by customizing the markers for a series.
First, let's use clip art for a marker, as follows:
- Click the Insert tab and click Clip Art in the Illustrations group.
- Enter a Search For topic and click Go.
- Click the appropriate icon in the Clip Art task pane. You can insert the clip art right into a blank sheet for temporary storage.
- Most likely, you'll need to resize the file. I recommend that you use a corner handle when reducing the size to maintain ratio.
- Select the object and press [Ctrl]+C to copy it to the Clipboard.
- Next, select the chart sheet and then click the line for which you want to substitute markers.
- With the line selected, press [Ctrl]+V and Excel will replace the default markers with the clip art.
As you can see, this is a surprisingly easy process. When replacing Excel's benign markers, perhaps the hard part is choosing the actual marker. My best advice is to respect the information and your audience and remember your chart's purpose. Gold stars and smiley faces aren't bad. In fact, in the right circumstances, they can be fun and effective, but they'd be a bit out of place in most business applications.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.