Excel 2010: Pictograph (Graph With Pictures)

Excel Chart provides a way to represent data visually, but by customizing chart we can convert it in to pictograph (graph with pictures). It is an ideogram which convey its meaning through depicting images which resembles real-world objects, eventually making chart self-explanatory. Enhancing the chart would be very useful, it makes your audience comprehend the table data, without even looking at it. In this post we will be creating a simple pictograph.

Launch Excel 2010, and open datasheet for which you want to create pictograph.

For instance, we have included Office Items datasheet containing, Products, and No. Of Products, as shown in the screenshot below.

officeitems Excel 2010: Pictograph (Graph With Pictures)View in gallery

To start off with, first we need to include a simple column graph for the table Office Items. For this, select the column for which you want to create a chart, navigate to Insert tab, and from Column, select the basic 2-D Chart, as shown in the screenshot below.

chart Excel 2010: Pictograph (Graph With Pictures)View in gallery

Upon click, it will automatically create the chart for you, showing Products in x-axis, and No. Of Products in y-axis. Give it an appropriate name at the top of the chart.

office items graphView in gallery

Now we will create Pictograph by adding picture instead of bars in the graph. For this select the first bar in the chart, click the bar two times (not double-click), to select it exclusively, as shown in the screenshot below.

booksView in gallery

Now head over to Insert tab, and click ClipArt.

clipartView in gallery

From ClipArt Pane, we will search for book clipart, right click the clip art you want to include, and click Copy.

bookView in gallery

Make sure that book bar is selected in the chart, now paste this image by pressing Ctrl + V. You will see stretched book image instead of bar, as shown in the screen shot below.

book clipView in gallery

We want to show the number of books in the graph, by depicting same number of book images. Right-click the stretched image and click Format Data Point.

format dataView in gallery

Upon click, Format Data Point dialog will appear, from Fill, enable Stack and Scale with option. Hit Close to apply.

format optionsView in gallery

Number of book images as defined in table which will be shown in the chart.

imagesView in gallery

Now repeat the procedure for the other bars to place suitable images.

pencil 1View in gallery

As you can see in the screenshot below that we have replace bars with images.

chart completeView in gallery

Now we will change the style and design to make the items more prominent. For this, select the chart, you we will notice three new tabs will appear. Choose suitable style, color, design, layout, chart type, gridlines, etc by accessing different groups from these tabs.

designView in gallery

items completeView in gallery

You can also check out previously reviewed guides on Scatter & Trendlines In Excel 2010 & Insert Slicer In Chart Excel 2010 (New Feature).

  • Pingback: Comparative Histogram In Excel 2010()

  • ferlyn tan

    thank you very much :)) :bd this help me a lot

  • ga ga

    this sucks thats a bar graph with pictures not a pictograph

  • Milan

    Very helpful… info.. 🙂

  • Rajiv Kumar – excelinhindi.com

    really nice – why i missed , thanks a lot

  • Rajiv Kumar – excelinhindi.com

    excellent trick