This really was something that annoyed me until I found out how to fix it!  If you have large numbers on your Y axis it can take up waaaay too much space.the sales here may be good but the Y Axis...

The default settings for bar chart in Excel mean that they appear on your charts with a lot of space between them.  This default setting is sometimes not the look we want for our charts in...

I have included this tutorial as part of the Pivot Table Tutorials as I have found to fully understand and get the best out of this fantastic Excel function you need to know the core terminology,...

Recently a colleague was having an issue with their Pivot Table, they claimed some if their data was 'missing', a subscriber to my newsletter also had this issue so I thought I would cover it in...

Typically most people create charts with one style  such as a column chart, a line chart, or a pie chart.  If my chart has more than one data series for example monthly targets and actual monthly...

There are many ways to create dynamic charts in Excel, but today I want to share with you one of the most simple. In fact I think it is THE simplest way I think I know to create fun simple but...