Quick Steps to Make Effective Data Visualisations

Original.png

This is an example of the default settings for a bar chart in Excel. This is functional but could be far more effective; here are my main steps I use to create quick, effective data visualisations.

Advertisements
Data Visualisation Excel Examples How to

Nintendo Console Dashboard – Linked Pictures

I was taking a glance around the Excel tag in the WordPress Reader, when I came across the following blog post about Linked Pictures in Excel.

This was a little bit of a revolution to me; when I made the Nintendo console dashboard I struggled to work out a passable fix for including dynamic pictures in VBA, ultimately deciding to scrap the code and just go with no pictures. Now that I know how to use Linked Pictures with named ranges to allow dynamic updates I could easily go back and update the old Dashboard!

Excel Examples

Game Dev: Balancing Adventurer Guild Simulator

For the past 2 weeks I’ve been working on developing a game in my spare time: it’s tentatively titled ‘Adventurer Guild Simulator’, as it’s about running an adventurer guild in a fantasy setting (think Dungeons and Dragons). In the game you’ll be hiring adventurers to go on quests to raise the reputation of the guild and to thwart the plans of villains within the area. Adventurers will be fighting monsters, solving the secrets of locations, gaining experience and collecting riches on your behalf. The game is being developed in Unity, which I can highly recommend to any budding game developers!

Excel Examples Game Dev