Using the New Shape Maps in Microsoft PowerBI
Could the new Map Shapes visualisation be a game-changer for PowerBI? I’m going to look at what the new feature does, and why it could well be. Although this is, I think, the first time I’ve written about Microsoft’s PowerBI, anyone who knows me personally will know I’ve been a huge fan, following its progress
EU Brexit Referendum – A Look Behind The Numbers
The EU Referendum has been a huge talking point, right around the world. Whatever happens next, the effects of this vote will be felt for generations to come. Taking the politics out for a moment, and returning to something a little more ‘my area’, I thought I’d take look at what proportion of registered voters
Showing Data Bars as a ‘Proportion to Total’ in Excel
Use this trick to show Excel Data Bars (the in-cell micro-chart) as a ‘percentage to total’ rather than relative to the max value
Creating Sunburst & TreeMap Charts in Excel 2016
Familiarise yourself with two of Excels fantastic new Chart Types – the Sunburst, and Treemap (collectively known as Hierarchical charts)
Using stacked images for your Excel Charts
Create colourful, engaging charts using stacked images in this comprehensive Excel walk through.
Creating Waterfall Charts in Excel 2016
Excel 2016 has given us a plethora of useful – and long overdue – chart types for us to work with. One of these, is the Waterfall Chart I‘ve written before about how to create a Waterfall Chart in Excel – it has long been one of the more challenging chart types to re-create, so
Pie Charts – how not to use them!
I originally posted this to my LinkedIn Profile, which you can find here, but thought I’d share it on here as well!
~
Plenty has been said before about whether or not you should use Pie Charts to present your data.
A good article covering their main pitfalls can be found here;
and a slightly lighter take on them can be found here;
Yet, it was my own father who reminded me that Pie Charts can be put to good use, as was the case with Florence Nightingale. (Though, they were of the somewhat more useful Rose Diagram type than bog standard Pie chart, but I take the point!)
Having said that, I came across this little gem, on the BBC news website of all places, which really must be the single worst usage of Pie Charts I’ve ever come across
Add Labels to Outliers in Excel Scatter Charts
Scatter charts are a great way to present the relationship between two data points
In my example, I’m using a scatter charts to monitor student test results – I want to compare their latest test score against how that score has changed from their last test.
Insert an Excel Spreadsheet into a Word or Powerpoint Documents [2010,2013]
Can you believe that with all the articles I’ve written to this site, I’ve yet to do one specific to Word? Which is ironic, given I write and publish most of the articles from Word.
There is of course a logical reason for that – it’s just not a tool I use as much as other applications.
And, you’ll be comforted to know, this article isn’t a complete departure from my more frequent Excel related articles!
(I’ve written the article based on using Word, but the exact same approach is valid for Powerpoint as well)
Embedding Excel worksheets in Word:<
Most Read Articles
