7
6
How could I make a chart similar to the one below?
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?
7
6
How could I make a chart similar to the one below?
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?
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)
You should now have your Excel Chart with images, similar to what you want.
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:
Thanks to @Rik for the suggestion.
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.
Installation:
Open Excel 2013 and write these values in the first 4 cells (A1:B2)
Click "Insert" at the ribbon bar and choose "Apps for Office"
Select "People Graph" and click "Insert"
Hover over the app window, click the table icon and press the "Select your data" button
Select your data
You also have the ability to change the diagram's title (I chose "What do they like?" in the first picture)
You can play with the pre-defined themes, colors or cliparts by clicking on the wrench icon
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!
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.
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