Data Visualisation

Creating a picture axis

Using pictures as axis points in Excel..

User Friendly

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

View original post 62 more words

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 )

Google photo

You are commenting using your Google 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 )

Connecting to %s