Home »  Software »  Office Suite Software

How Do I Create a Pictograph in Excel® 2010

January 04, 2013  |  Difficulty: Medium

how to enhance your next presentation by  creating a pictograph

Make your next presentation more interesting and easier to understand by incorporating a pictograph using data from Microsoft® Excel®. A pictograph uses pictures to represent numerical data in a chart or graph. Unlike standard diagrams, a pictograph incorporates pictures to replace the colored columns or bars most often seen in presentations, grabbing your audience’s interest through the use of color and images. Learn how you can enhance your next presentation by creating a pictograph with Microsoft® Excel® 2010. 

How to create a pictograph:

  1. Launch the Excel® 2010 application and enter your data into a worksheet or table. Then, select the data (include the field headings and title).
  2. Switch to the “Insert” tab and click on the chart you want to use in the “charts group”. Choose a chart with elements that can support a picture (a bar chart, for example).
  3. In the chart, select the first element to which you want to add a picture, and then double-click the element. The picture will be inserted in all the elements that are selected, so make sure that the selection border is around only the first element.
  4. In the newly opened “Chart Tools”, switch to the “Format” tab, and then click “Format Selection” in the “Current Selection” section.
  5. Click on the “Fill” button in the left navigation pane of the Format Data Point dialog box.
  6. In the right pane, click “Picture or texture fill”.
  7. Under “Insert from”, click on the “Browse” button and browse for a picture file.
  8. Choose whether to “Stretch” or “Stack” the image.
  9. Repeat steps 3 through 8 for each of the other elements.



Most Popular Articles:

What Is the Best Backup Software for Me

Internet Security Solutions Detect Legitimate Soft

How Do I Block Internet Intruders from Spying

How Do I Choose a Data Backup Software

How Do I Install a FREE Spyware and Adware Blocker

Related Articles:

how to insert a chart into a Microsoft® Excel® 2010 spreadsheet

How Do I Make a Chart in Microsoft® Excel® 2010

how to convert your Microsoft® Excel® columns to rows with ease.

How Do I Convert Rows to Columns in Excel®

how to sort data in your Microsoft® Excel® 2010 spreadsheet or table

How Do I Sort a Row or Column in Microsoft® Excel®

how to set the password protection on your document in the Microsoft® Excel®

How Do I Password Protect Excel® Files

how to set up the universal sorting for any column in Microsoft® Excel® 2010.

How Do I Set Up Universal Sorting in Excel® 2010

Help Us Spread the Word!

Love us on Facebook to stay updated.

Stay aware and get our best content on health, celebrity, travel, living, career and the technologies that will change the world.