We will show you some sample table designs in Excel. Sample table designs Because of Excel’s structure, you do not have the same flexibility as you would in a word processor. Or, in a desktop publisher app. However, with some creative thinking, designing fancy stuff is always possible. Also, the good thing about tables in […]
Scatter dots chart with trendline for Excel. Download Overview of scatter dots chart with trendline The scatter dots chart allows you to display data using x, y coordinates. It is a great way to show the spread of many data points. In addition, we include a trendline with the formula to help you see if […]
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. […]
Scrambler is a word unscramble game for Excel. Overview of Scrambler We developed this game many years ago, using Excel 2003. During that time, we were experimenting. Fortunately, the experiments were successful. On the other hand, we did not continue to enhance the game. Most likely, other outside jobs got in the way. Anyhow, it […]
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 Education home
This quick tip video shows you how to show or hide an object with a shape in Excel. For the purpose of this tip, we use Excel 2007 or higher, on a Windows PC. In addition, we use a mouse with left and right button functionality. Show or hide an object with a shape So, […]
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 stacked pill bar chart is similar to our original pill bar chart. However, with a stacked chart, you have more options. Firstly, you can enter a value for the blue series and a value for the red series. And, it looks like a pill with those two series and rounded corners. Now, that is […]
Standard bar chart for Excel The standard bar chart for Excel is a very common chart that people use in all types of businesses. Overall, there is not too much to this graph. All you have to do is enter your categories and your values and watch it go to work. Now, the only thing […]
The sunburst chart The sunburst chart is a donut chart with multiple levels of series. In most cases, the totals of the inner donuts expand to more detail in the outer donuts. Download Chart library
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 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 […]
