Advanced Excel Charts
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 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.