The Marimekko – one level chart Believe it or not, the Marimekko – one level chart, is actually an area chart in Excel. Now, isn’t that something? It is a unique chart. And, in the beginning, it took a while learning how to create it. But now, we have one where you can just plug […]
Pill Bar overview The pill bar with average line chart is similar to a regular bar chart. Instead, with this chart, the two endpoints are round. Thus, you get what looks like a pill. Of course, as with the bar chart, this chart is shows everything in a horizontal manner. Now, with all that said, […]
How to put average line on a bar chart in Excel This quick tip shows you how to put average line on a bar chart in Excel. Set target goal So, you may hear people say “target line” for this type of chart. For the most part, it is the same idea. Except, we use […]
The rounded column chart with average line is very similar to our column with average line chart. Basically, it shows data across categories. In addition, the average line shows the central tendency of the values. Moreover, you can visually view which categories are above or below average. Adjusting the Rounded Top Now, depending on the […]
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. […]
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 […]
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. About the chart […]
