In Excel, unless you have a dynamic data set, or your data is an Excel table, then you may need to manually add data to your existing Excel chart if you want to display more data than your original...

Excel takes a snapshot of your data set when you create a Pivot Table report and stores it in a pivot cache.  This is just an area where your data source is duplicated for easy access, this is...

This tip is really useful for Excel dashboards or anywhere that space is of a premium on a worksheet or, where your data set is just too large to comfortably display. Let's look at using a scroll...

If you have extra data that you need to add into your charts, then the usual way in Excel 2007 onwards of adding data is to drag the blue box line with the mouse but this will work only if your chart...

Before I found out about this little tip, the multiple stacked report filters in my Pivot Tables REALLY annoyed me. So, here is how to avoid all of those stacked up messy filters. Yuk. I have used...