Creating a picture axis

If like me, you like to create interesting graphs in Excel, you may have wondered at one point or another whether it is possible to have pictures on your axes instead of text.  In actual fact it is really very easy to do this.  You just need to install some dingbat fonts (e.g. wingdings and wingdings 2) on your machine.  Then simply adjust the font of the axes to match the font (and icons) you want to use.

For example, in the graph below I have used a font called “Social font face” which is free to use for personal use.

social media graph

Personally, I think the logos of the different types of social media are a lot easier to read and more recognisable than text.

Another example using a font called “Face“:

faceI’ve enclosed the two excel spreadsheets here for you to download and use: social media & face.

What do you think?  Is it useful?  I think if you are wanting to grab attention and or present data in an interesting way, it can be great, however, it can also be overdone and look unprofessional if you choose the wrong icons, so be careful.


+Alesandra Blakeston


3 thoughts on “Creating a picture axis

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s