But this chart assigns both X and Y axes with two sets of data.ĭifferent from normal column showing one-dimension data by column heights, the Variable Width Column Chart can show two sets of values across two dimensions by both column widths and column heights. The Dot Chart uses markers to show data, which looks like the scatter chart. The Difference Area Chart draws two lines for two sets of data, and use the filled room between the two lines to show the differences between two sets of data. The Bar with Bubbles Chart enhances the bar chart, and helps us show two sets of data horizontally: use bars to show one set of data in left side, and use bubbles to show the other set of data in right side. The matrix bubble chart represents data points by bubbles in a matrix, which is fit to compare multiple sets of data horizontally and vertically.Ī general clustered bar chart can only show a set of data. This feature helps to create a Matrix Bubble Chart with only several clicks in Excel. This Different Arrow Chart is similar as a clustered column or bar charts, but add arrows and percentages to show the differences between two sets of data.

The Threshold Value Chart compares the data points with a given threshold value, and show the differences between data points and the threshold value by column direction, column height, and color. You can easily create a Slope Chart in Excel to visually show the difference between two categories at two times. It also supports to create a chart based on the given actual and target values without figuring out the completion percentages in advance. The Progress Bar Chart can create a chart based on the given completion percentage. This chart supports to change border color, background color, and foreground color of the ball.Ĭomparing with above Progress Ring Chart or Percentage Ball Chart can only show the completion percentage of one project, the Progress Bar Chart can show the completion percentages of multiple projects in one chart. The Percentage Ball Chart is commonly used to show the percentage of something occupied or remaining, or the completion percentage of a project. This Progress Ring Chart is commonly used to show the completion percentage of a project, with showing the completion percentage in the middle of doughnut.

The Dumbbell Plot chart can be used to compare two sets of data, and show the differences between them with lines in a chart.

Kutools excel merge cells