» 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.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Word 2002
- The 22 Immutable Laws of Branding
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Financial Modeling - 2nd Edition
No comments have been submitted.
