Below are different tables and diagrams for SQL joins. So, these illustrations show seven connections between two tables. SQL joins table The diagram below shows the original table, and the results of each join structure. SELECT syntax for joining tables Related ASCII character code table – Reference guide Color scheme table for Excel Using the […]
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 Excel Effects home As you may know, charts help you show data and information to your audience in a more visual […]
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 impossible box The impossible box is always a fun design to create. Especially, in Artplotty Grid 21 (or APG). So, to create this kind of design in APG, you will probably need to redraw the datasets a few times. However, it is still a fairly simple design. Tip: For some designs, you may want […]
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 Numbers Game will help you pick your winning numbers. It is now hosted by Techronology Inc. If you are feeling lucky and know how to pick numbers, then click play now to get busy. Otherwise, continue learning more. Play now Overview of the Numbers Game The Numbers Game is a way to help you […]
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 […]
Note: The United States Daily Report is a sample dashboard. You can download it and change it for your own purposes. We do not offer support for this product. Overview of the United States Daily Report The United States Daily Report (or USDR) is a dynamic dashboard for a major company in New York City. […]
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 […]
Unit circle trigonometry chart for Excel If you ever thought about creating Pac-man or rotating an object in orbit, then the unit circle is a great place to start. Requirements Microsoft Excel 2007 or higher or compatible. Download Chart library Excel Effects home Charts As you may know, charts help you show data and information […]
