August 17, 2011
Create a Pivot Table Direct From Access
Did you know you can analyse data from an Access database in an Excel Pivot Table without importing the data
Read More
August 10, 2011
Excel Chart Axis Label Tricks
So, you’ve analysed your data and plotted your chart but the axis labels are all skewey (technical term). Let’s look
Read More
August 3, 2011
Excel Chart Secondary Axis
One of the Excel questions I get asked often is; how do I add a secondary axis to my chart?
Read More
July 20, 2011
Excel Histogram Charts and FREQUENCY Function
A Histogram, also known as a frequency distribution, is a chart that illustrates the distribution of values that fall into
Read More