When you are charting the whole year in a line chart you might want to show the actuals up to a point and then the budget from then on. The budget could also be a dotted line. Here’s a way to do that.
When you have a vertical list that you need to make horizontal you can use the TRANSPOSE function to switch it. There is an alternative function that gives you extra options.
Reading time: 2 mins
When creating sparkline charts in Excel one of the problems is that the vertical axis doesn’t always start at zero. It is a manual process to reset the vertical access to zero and a macro can make it much quicker and easier.
Learn how to record macros as well as the tips, tricks and traps.
This a recording of a live webinar from November 2025. The live session rating, based on over 50 responses, was 92%!
When you import a CSV file using Power Query any extra rows are automatically included. Unfortunately, extra columns are NOT included. Here’s how to fix that.
You may have started to see the strikethrough format displaying in Excel and wondered why. It means the formula’s values haven’t been updated and a calculation is required.
