How can I make a pictograph?

7

6

How could I make a chart similar to the one below?

the chart

Of course, I could use an app like Microsoft Paint, but that would be too time-consuming and awkward. What would be a simple way to do this?

Miscreant

Posted 2013-12-01T16:34:34.587

Reputation: 363

4This type of chart is called a pictograph. – Rajib – 2013-12-01T17:47:55.933

1@Rajib or an Infographic is corporate speak. – Austin T French – 2013-12-01T19:56:00.657

Answers

16

You can get close in Excel:

Create your graph, as you normally would by selected your data points and inserting a graph.

Once you have your graph, select the actual graph item (In this case the bars themselves)

enter image description here

  • Now right click the bar, and choose Format Data Point
  • Go to the Fill tab
  • Check Picture or Texture Fill
  • Select your image from the File... button
  • Set Stack and Scale to units per picture to 1 if you want one image per unit in your datachart

enter image description here

You should now have your Excel Chart with images, similar to what you want.

enter image description here

There are some short comings, but it gets you close with more or less standard software.


EDIT

By using a stacked bar and switching the row / column values and then changing the 2 fill pattern to a new Orange stick figure, I was easily able to get closer:

enter image description here

Thanks to @Rik for the suggestion.

Austin T French

Posted 2013-12-01T16:34:34.587

Reputation: 9 766

1I'd prefer something more visually appealing. – Miscreant – 2013-12-01T17:33:41.367

7realize this took 20 seconds in Excel and paint to make the stick figures. Making it look more refined would not be hard, starting with a more professional base graphic. – Austin T French – 2013-12-01T17:36:41.033

1

+1 - Love the stick figurines ;) @Miscreant With it you should be able to create something like this or this. Not sure if you can get a different color per line. You also may want to look into this article from Microsoft mentioning a free "People Graph app v1.1 for Excel 2013". I didn't post that as a separate answer because i think this one works good enough (and i don't have Office2013 handy to test it myself)

– Rik – 2013-12-01T19:08:32.857

@Rik to get different colors per lines, you can edit each bar and use a different image. So for my stick figures, I could use flood fill for the black lines and paint it blue, red etc and save a new image / color for each bar. So doable for sure. – Austin T French – 2013-12-01T19:49:11.267

9

Here is another solution using Excel 2013.
All credits go to Rik who mentioned the People Graph app in a comment.

enter image description here

  1. Installation:

    • Navigate to the People Graph app site with your internet browser
    • Login with your Microsoft account
    • Click "Add"

  2. Open Excel 2013 and write these values in the first 4 cells (A1:B2) enter image description here

  3. Click "Insert" at the ribbon bar and choose "Apps for Office" enter image description here

  4. Select "People Graph" and click "Insert"

    • Hover over the app window, click the table icon and press the "Select your data" button enter image description here

    • Select your data

    • You also have the ability to change the diagram's title (I chose "What do they like?" in the first picture)

  5. You can play with the pre-defined themes, colors or cliparts by clicking on the wrench icon enter image description here

ComFreek

Posted 2013-12-01T16:34:34.587

Reputation: 409

1Exporting the chart as an image file: right-click it and choose "Save Picture As". – Miscreant – 2013-12-02T12:40:39.853

4

If you can find a nice Unicode character to represent your figures, you can use Excel's REPT formula:

=REPT("☺", 8)

Just zoom in in Excel (or change font size) et voila!

benshepherd

Posted 2013-12-01T16:34:34.587

Reputation: 1 448

2

These style of images are generally called infographics. Unless you're looking for something dynamic or programmatically generated, I would forego the Excel suggestions, and focus on something like Photoshop or GIMP.

The caveat being, the skills to use these programs, or at least make the end product to look good, will take time to develop. Which can be it's own kind of reward.

wgj

Posted 2013-12-01T16:34:34.587

Reputation: 121