Final Friday Fix: January 2018

On the final Friday of each month, we’re going to set Excel for you to puzzle over so that you can get your “Excel fix”. Challenge your office colleagues to see who can solve the puzzle quickest. There’s no prizes at this stage, you’re playing for bragging rights only!

This time, let us return to charts. The Excel chart engine often does not always do what the people would like it to do and sometimes one is left scratching their heads as over simple formatting issues.

Today’s challenge is this - a bar chart shows some key statistics as follows:

Statistics for this chart were gathered from here.

However, we’d like the country labels to be left aligned, to coincide with the laterality of hands! What would be the best way to approach that?

Please find the following attached Excel file to experiment with.

The solution will be posted on Monday so please check back then!