Excel Charts

So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look at our options to make this better: Chart Axis Alignment We could use the alignment tools. Right-click axis > Format Axis > Alignment. But before you waste time doing this there is a better way. …

One of the Excel questions I get asked often is; how do I add a secondary axis to my chart? It’s actually quite easy but there is a trick to it. Excel Secondary Axis Trick Step 1 Let's take this data. Now, the first thing you want to do is simply insert your chart. Insert …

A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into groups. Since my 5 year old is big into his football (soccer) we’ll take goals scored as an example…even though in 5 year old's football matches you’re not supposed to count the goals scored! Below …