Advanced Excel Charts Create Waterfall Chart A waterfall chart, also named as bridge chart is a special type of column chart, it helps you to identify how an initial value is affected by an increase and decrease of intermediate data, leading to a final value. Create Band Chart A band chart can help us to quickly figure out if a series of data is within a certain range at a glance. It is a line chart combined with horizontal bands in different fill colors to display different boundaries of the defined data range. Create Bullet Chart A bullet chart can help to compare a measure to one or more related measurements, it helps you to judge the performance of the actual value at a glance according to the gradient color it locating. Create Box and Whisker chart A box and whisker chart is used to display the statistical analyses which helps to show you how numbers are distributed in a set of data. For example, with the help of the box and whisker chart, you can display the statistical data of test scores between different subjects to identify which subject need more attention for the students. Create Funnel Chart A funnel chart showing values across multiple stages in a process, which is often used in sales and marketing departments. It is composed of a bar chart, but all bars are centered to make a funnel shape in order to give a visual picture of the stages in the process to the readers. Create Heat Map Chart In Excel, a heat map chart looks like a table which is a visual representation that shows a comparative view of a dataset. If there is a large dataset in your worksheet, it’s really hard for you to identify the lower or higher values at a glance, but, in heat map, the cell value is shown in a different color pattern so that we can see the larger data or smaller data quickly and easily. Create Gantt Chart Gantt charts, which was invented by Henry Gantt, are generally used in project management. It can help to plan, manage and track your projects visually, free you from large task data tables. Create Pareto Chart A pareto chart is composed of a column and a line charts, where the column bars represent the frequency values in descending order, and the line indicates the cumulative totals on a secondary axis. It is used to analyze the significant areas of defects in a product, and determine the improvements that increase the value of a company. Create Speedometer or Gauge Chart A gauge chart is composed of two Doughnut charts and a Pie chart, it shows the minimum, maximum and current values in the dial. It can be used for presenting sales performance of representatives or work completed as against total work or other situations with a visualization way. Create Histogram Chart A histogram chart can represent the distribution of numerical or categorical data approximately. For example, you can easily figure out how many students fall into the scores “48 - 60”, and the number of students that have scored between 60 and 78, and so on through a histogram chart. Create Step Chart A step chart is used to show data which changes at irregular intervals, and keep constant for a period until the next change comes. For example, after creating a step chart to diaplay the annual sales, you can easily spot the time period where there was no change and compare the magnitude of sale change at each year. Create Thermometer Chart Thermometer chart is used to make a comparison between the actual value and a given target value to show the progress if they have achieved the target. For example, it can be used to a few scenarios, such as: analyzing sales performance, analyzing employee satisfaction rating, comparing budget and expenditure and so on. Create Actual Vs Target Chart In daily work, we often set goals for a specific period such as month, quarter, year, etc., and then measure if the goals have been hit based on the actual completion. For comparing the actual values against the targets and displaying the difference at a glance, the actual vs. target chart is your best choice. Column Chart With Percentage Change In Excel, you may create a simple column chart for viewing the data trends normally. For making the data looks like more intuitively to display the variances between the years, you can create a column chart with percentage change between each column. Create Bell Curve Chart The bell curve char also named as normal distribution curve chart reflects the distribution of random variables. In a bell curve chart, the highest point is the one that has the highest probability of occurring, and the probability of occurrences gradually decrease towards either side of the curve. Create population pyramid chart A population pyramid chart is a specific bar chart which shows the age and gender distribution of a given population, it is used to indicate the current situation of population and the trend in population growth. With the help of this chart, you can get the information on degree of population aging, number of people of child-bearing age, future birth and death rates, etc. Create Progress Circle Chart A progress circle chart is a type of doughnut chart which is used to represent the percentage complete when you want to monitor progress towards a target in Excel. It is more interesting and compelling than the progress bar chart.It is used to show progress in the news, business reports and even in some software loading or refreshing commonly. Create progress bar chart A progress bar chart is a type of bar chart which can help you to monitor progress towards a target, it is a simple and visually chart, this article, I will talk about how to create progress chart in Excel. Create Bi-directional Chart A bi-directional bar chart is used for comparing two sets of data side by side along a vertical axis. In this tutorial, we will demonstrate how to create a bidirectional bar chart in Excel in details. Create Dumbell Chart Dumbbell chart also called DNA chart, which can help you to compare two points in a series that are on the same axis. For creating a dumbbell chart in a worksheet, we provide a step-by-step guide in this tutorial to help you get it down with ease. Create Lollipop chart Although the lollipop chart plays the same role as column or bar chart, it is more beautiful and unique in the appearance, which can be more attractive for readers. In this tutorial, we are providing a step-by-step guide to show you how to create a lollipop chart in Excel. Create Milestone Chart Milestone chart, also known as timeline chart, is a kind of project management chart which can help to track specific points along a project timeline. In this tutorial, we provide a step-by-step guide to show you how to create a milestone chart in Excel. Create Slope Chart A slope chart helps to compare data changes over time by plotting the change between two points only. As the below slope chart shown, you can easily figure out which months increase stably, which months decrease speedily than other.... In this tutorial, we provide a step-by-step guide to show you how to create a slope chart in Excel. Create Slider Bead Chart In Excel, a slider bead chart is a type of progress bar chart which is composed of bars and circle markers as above screenshot shown. Compared with the normal progress bar chart, the unique thing about this chart is that it uses circle markers to represent the project status. This type of chart is more intuitive and beautiful, creating this chart in your daily work will make you stand out from others. Create stacked chart with percentage In Excel, it is easy for us to create a stacked column chart with data value labels. But, sometimes, you may need the stacked column chart with percentage values instead of the normal values, and display the total values for each column at the top of the bar as above screenshot shown. Create arrow variance chart In Excel In Excel, the arrow variance or different chart is a type of clustered column or bar chart with up or down arrow to indicate the increase or decrease percentage of the two sets of data. For example, if you want to display the sale variance in compare of previous year, you can use green and red arrow to display the percentage change as above screenshot shown. This article, I will talk about how to create this complex type of chart in Excel. Budget vs Actual Variance chart In Excel, a Budget vs Actual Variance chart is used to compare two sets of series data, and display the difference or variance of the two data series. If the differences are negative values, one colored bars or columns are displayed, if positive values, another colored bars or columns are displayed as above screenshot shown. Create bar with bubbles chart A bar with bubbles chart can help to to display two sets of data for different categories in Excel. This tutorial provides a step-by-step guide for you to create a chart that combines bars with bubbles. Create dot plot chart In Excel A dot plot chart is a great alternative to the bar or column chart to show the distribution of data visually. In this tutorial, you will learn how to create a dot plot chart in Excel step by step. Half pie / doughnut chart Normally, you may create a pie chart or doughnut chart to show proportions of a whole. By default, the pie chart or doughnut chart is a circle, this tutorial is going to show you how to display only half of the pie chart or doughnut chart in Excel. Create matrix bubble chart A matrix bubble chart can be used for comparing more series of at least three sets of values and show the relationship between them by placing the bubbles in a matrix permutation way. In tutorial demonstrates detail steps to create a matrix bubble chart in Excel. Create bubble chart in Excel A bubble chart is an extension of the scatter chart in Excel, it consists of three data sets, X-axis data series, Y-axis data series, and the bubble size data series to determine the size of the bubble marker as above screenshot shown. The bubble chart is used to show the relationship between different datasets for business, economic or other fields. Create butterfly chart in Excel Butterfly chart is also named Tornado chart which is a type of bar chart composed with a gap in the center showing categories and two bars displayed side by side as above screenshot shown. The butterfly chart is used to compare two sets of data series so that the difference between the two data can be analyzed at a glance. Create combination chart in Excel A combination chart is a type of chart which combines two or more different charts in Excel, the most common combination chart is a combination of column chart and line chart as above screenshot shown. With the help of this type chart, you can display two different data sets together. When the values from one series is too large or small compared to the other data, this combination chart also can do you a favor. Create project status spectrum chart This tutorial will talk about how to create an especial chart – project status spectrum chart in Excel. The project status spectrum chart is a type of bar chart with a slider block which the bar is filled as a spectrum from red to yellow to green to represent the project status as above screenshot shown. Create radial bar chart in Excel In Excel, the radial bar chart evolves from the classical bar chart, it is also called as multilayered doughnut chart because of its layout as above screenshot shown. Comparing with the normal bar chart, the radial bar chart is displayed on a polar coordinate system, which is more professional and impressive for people, furthermore, it allows for a better use of space than a long bar chart. Create Color Grouping Chart In some cases, you may need to create a column or bar chart with different colors for the bars based on values. For example, if a value is greater than 0 and less than 60, this series in the chart will be colored blue; and if a value is greater than 60 and less than 79, it will be orange. Different range scopes correspond to different colors. This tutorial demonstrates steps to help you creating a color grouping chart in Excel. Create Forecast Chart A forecast chart can help to visually predict data trends in the future. This article is going to show you how to create a forecast chart directly based on data in a worksheet. Create Marimekko Chart Marimekko chart is also known as Mosaic chart, which can be used to visualize data from two or more qualitative variables. In a Marimekko chart, the column widths show one set of percentages, and the column stacks show another set of percentages. This tutorial will demonstrate the steps to create a Marimekko chart in Excel step by step. Create Multi-Level Category Chart A multi-level category chart can display both the main category and subcategory labels at the same time. When you have values for items that belong to different categories and want to distinguish the values between categories visually, this chart can do you a favor. This tutorial demonstrates methods to create two kinds of multi-level category charts in Excel in details. Create Variable Width Column Chart Normally, a standard column chart displays all columns with the same width. You can only compare data by the column heights in a column chart in Excel. Is there any method to create a variable column chart so that the columns can vary in both width and height? This tutorial provides a step-by-step guide to help you create a variable width column chart in Excel. Create chart with average / target line In Excel, it may be a common task to insert a horizontal or vertical line to a chart, the horizontal or vertical line may reference some target or average value. This type of line makes it easy to compare the actual values versus the target or average value, and with the help of this line, you can easily see where values are above and below this reference value as above screenshot shown. Create a percentage ball chart Normally, we are displaying progress with an advancing bar chart. However, In Excel, we can visually display percentage completion with other different charts, such as a progress circle chart. This tutorial demonstrates steps to create a ball chart that tracks the percentage completion of a project visually in Excel.
