Jul 23, 2020
Creating a chart with a secondary axis
Here is how to show two different types of information on the same chart; especially if the two types of information are on different scales (one set of information is a [...]
Nov 14, 2020
Charts that aren't charts
In Microsoft Excel, there are a couple of ways to create a 'chart that isn't a chart.' Each produces a graphical representation of data, but using different [...]
Sep 26, 2020
Dynamic charts in Microsoft Excel
Charts in Microsoft Excel are a great way of representing data graphically, but sometimes that data is subject to change and when it does change, we need our charts to [...]
Aug 21, 2020
Dress up and present your data with Power View
Power View is a feature of Microsoft Excel 2013 that allows you to create stunning interactive visual presentations of data from multiple sources. In this tutorial we [...]
Jun 12, 2020
Pinpoint your 3D chart's data points with drop lines in Excel
One of the frustrating things I find about Microsoft Excel, particularly when you're producing a chart, is the huge quantity of formatting options that are available. [...]