Tip Printed from ExcelTip.com

---

Replacing Data Markers with Pictures in Microsoft Excel


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.

1. In the Chart, select the desired data markers (if you want to replace them with the same picture).
2. From the Insert menu, select Picture.
3. 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.