Quick Steps to Make Effective Data Visualisations
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... Read More
-
-
HOW TO… Excel: Create a hierarchical series of drop down boxes
As a result of prodding around the excel subreddit I found a query from user innocuous_gorilla about creating drop downs that are dependent upon each... Read More -
HOW TO… VBA: Compare VBA Combo Box Values with Their Lists
Preamble So, a recent issue I’ve had using VBA to create UserForms to handle data input is data validation. Throughout my UserForm I’ve included a... Read More -
HOW TO… Excel: Create a Dynamic Data Range for a Chart
Continuing the theme of automatically updating charts, we’re going to look at how to make a chart deal with a dynamically changing data range. This... Read More -
HOW TO… Excel: Create an Automatically Updating Chart
Following on from our last series of HOW TO... Excel, we're going to expand the concepts used to create the dynamic data table and create... Read More -
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... Read More
