Excel

Scatter line chart with key stat lines for Excel

Scatter line chart with key stat lines for Excel The scatter line chart allows you to measure data in both directions, horizontally and vertically. Or, on an x/y scale. This kind of chart gives you more formatting options from a regular line chart. Overall, this chart is very popular in financial firms, particularly, investment banks. […]

Show developer ribbon in Excel – How to

Show developer ribbon in Excel. How to show developer ribbon in Excel This quick video tip shows you how to add the developer ribbon in Excel. The video Below is a video that shows you how to add the developer ribbon to the menu, in Excel. Related Developer ribbon in Excel – Quick glance Education […]

Show the immediate window in Excel VBA – How to

This quick tip shows you how to show the immediate window in Visual Basic for Applications (or VBA) for Excel . Show the immediate window The immediate window allows you to test single lines of code. In most cases, you use Debug.Print to run single line commands in VBA. The video So, here is a […]

The butterfly chart for Microsoft Excel

The butterfly chart. Download Overview of the butterfly chart So, before you say, that is a tornado chart, or a football chart, yes, we know about the alternative names too. However, we like the name butterfly the best. On the whole, it sounds better than the other two options. If you create this chart right […]

The Marimekko – Two-level chart for Excel

The Marimekko – Two-level chart Believe it or not, the Marimekko – two-level chart, is actually a stacked area chart in Excel. It is very similar to our one-level version. Overall, it is a unique chart. As with the one-level, there is a learning curve. Unfortunately, you have to update the chart data manually, in […]

The special box chart for Microsoft Excel

The special box chart for Microsoft Excel Very similar to a bubble graph, the special box chart allows you to specify a starting point and an ending point. Moreover, it also does not matter if your starting point is less than or greater than your ending point. Still, it plots both points. Requirements Microsoft Excel […]

Ultimate monthly calendar for Excel

Ultimate monthly calendar for Excel So, the ultimate monthly calendar (or UMC) is similar to our dynamic yearly calendar. Overall, we are not sure if there were any issues with this tool. If there were, then it would probably involve functionality with our international users. In any case, feel free to download it and use […]