» Replacing Data Markers with Pictures in Microsoft Excel

CATEGORY - Excel Chart VERSION - All Microsoft Excel Versions

Shaking up the normal routine every once in a while cannot hurt. Jazzing up charts with interesting shapes makes a strong visual statement when displaying results. In the figure below, a number of pictures were added. You can add letters to data markers in any order you like or replace data markers with flags or anything else; just use your imagination.

In the Chart, select the desired data markers (if you want to replace them with the same picture).
From the Insert menu, select Picture.
From the Insert Clip Art pane (in Excel version 97 or 2000, choose from File menu), select the picture you want to use to replace the column.

Screenshot // Replacing Data Markers with Pictures in Microsoft Excel

Book Store:

VIEW ALL BOOKS

Recommended Books:

Email Tip

Print Tip

Add to My Tips

Rate This Tip



1	2	3	4	5

Rating: 2.82 Views: 48727

Possible Distortion

Mike Winstanley Posted on: 31-12-1969

This is a cool trick, but sometimes the picture is is so stretched out that it's unrecognizable. To fix this, right click the data series and select "Format Data Series". On the "Patterns tab", click the Fill Effects button. Then select "Stacked".