1. Dumbbell Plot Chart

The Dumbbell Plot Chart can be used to compare two sets of data and highlight the differences between them with connecting lines.

2. Progress Ring Chart

This Progress Ring Chart is commonly used to display the completion percentage of a project, with the percentage shown in the middle of a doughnut.

3. Percentage Ball Chart

The Percentage Ball Chart is used to show the percentage of an area occupied or remaining, or the completion percentage of a project. This chart supports changing the ball's border, background, and foreground colors.

4. Progress Bar Chart

Unlike the above charts that display only a single project’s completion percentage, the Progress Bar Chart can show the completion percentages of multiple projects in one chart. It can create a chart based on given completion percentages or, alternatively, generate a chart from actual and target values without pre-calculating the percentages.

It also supports creating a chart based on given actual and target values.

5. Slope Chart

Easily create a Slope Chart in Excel to visually show the difference between two categories at two different points in time.

6. Threshold Value Chart

The Threshold Value Chart compares data points with a specified threshold and displays the differences using column orientation, height, and color.

7. Difference Arrow Chart

Similar to clustered column or bar charts, the Difference Arrow Chart adds arrows and percentages to clearly show differences between two sets of data.

8. Matrix Bubble Chart

This feature helps you create a Matrix Bubble Chart in Excel with just a few clicks. The chart represents data points with bubbles arranged in a matrix, making it easy to compare multiple sets of data both horizontally and vertically.

9. Bar with Bubbles Chart

While a typical clustered bar chart displays a single set of data, the Bar with Bubbles Chart enhances it by showing two sets of data horizontally: bars display one set on the left side, and bubbles display the other set on the right side.

10. Difference Area Chart

This chart draws two lines for two data sets and uses the filled area between the lines to show differences between them.

11. Dot Chart

The Dot Chart uses markers (dots) to display data, much like a scatter chart, but it assigns both the X and Y axes from two sets of data.

12. Variable Width Column Chart

Unlike a standard column chart that represents one dimension of data with column height, this chart displays two sets of values by using both column widths and heights.

13. Marimekko Chart

The Marimekko Chart combines multiple stacked columns in a single chart, showing several sets of values across three dimensions.

14. Lollipop Chart

The Lollipop Chart reduces columns to lines and adds colorful circles at the end of the lines, making data points visually stand out.

15. Multi Series Area Chart

This chart combines multiple area graphs into one chart, allowing you to easily compare several sets of values.

16. Proportion Stacked Chart

This chart displays the proportion of each value in a series using small squares. It supports two types of graphics:

(1) A compound stacked chart that shows the proportion of each value.

(2) A chart that shows the proportion of each value with square filled cells.

17. BiDirectional Bar Chart

The BiDirectional Bar Chart places two sets of values on either side of the Y-axis, allowing you to easily compare them horizontally.

18. Multi Series Histogram Chart

This chart uses sets of columns to represent data and combines multiple sets into a single chart for easy comparison of series.

19. Copy Format to Other Charts

This feature copies the formatting of the currently selected chart and applies it in bulk to multiple charts in the active workbook.

20. Set Absolute Position of Chart

This feature moves the currently selected chart to a specified position and simultaneously resizes it to a specified range.

21. Add Sum Labels to Chart

This feature adds sum labels to the currently selected stacked chart.

22. Add Cumulative Sum to Chart

This feature adds a cumulative line with total accumulated labels to the currently selected clustered column chart.

23. Move X-axis to Negative/Zero/Bottom

This feature moves the X-axis to the bottom of the currently selected chart.

24. Add Trend Lines to Multiple Series

This feature adds trend lines to a scatter chart that contains multiple data series.

25. Change Chart Color According to Cell Color

This feature changes the fill color of columns, bars, scatters, etc., based on the fill color of corresponding cells in the chart data range.

26. Data Form

This feature displays data from a specified range row by row. In the Data Form dialog, you can view, add, delete, or edit rows of data.

27. Search (Kutools Features)

This feature helps you quickly find and enable a specified Kutools feature by entering a keyword.

1. Create simple drop-down list

Supports quick creation of a drop-down list based on a specified custom list.

2. Make up a number

Supports making up a decimal number or a negative number.

3. Send Emails

1) Adds hints to explain outgoing server settings.
2) Supports specifying a sending account when sending emails via Outlook.

4. Navigation Pane

1) The AutoText pane now displays AutoText groups by categories.

2) The Find and Replace pane now supports searching for keywords in hyperlinks and chart titles.

3) The Find and Replace pane now groups search results by sheet.

5. Reading Layout

1) HDPI support has been added.
2) The active cell will no longer be highlighted when being edited.

6. File Format Converter

1) Redesigned the interface of the File Format Converter dialog.
2) Now supports adding or managing passwords to open protected workbooks.
3) Supports OneDrive files and folders.

7. Super Filter

1) Supports adding scenarios to favorite folders.

2) Supports automatically saving scenarios when closing the workbook.

3) The “Open saved filter setting scenario” drop-down menu now lists no more than 10 recently used scenarios.

8. Number to Words

1) Added the “Not converted to Currency” option. If selected, it will not add “dollars” and “cents” to the converted words.
2) Added the “No commas” option. If selected, it will not insert commas in the converted words.

9. Charts

1) Changed the layout of the Charts drop-down menu and organized charts by categories.

2) Redesigned the interface of the “Quickly create a normal distribution chart” dialog.

3) Adjusted the running logic of the speedometer chart.
4) Improved the interface of the “Compared Bar Chart” dialog (Difference Comparison Chart) and added support for generating mini charts.

13. Welcome Tips

After installing Kutools for Excel, the Kutools tab is enabled and welcome tips are automatically displayed the first time you launch Microsoft Excel.

14. Undo

1) Improved undo logic: The system now notifies users that backing up data for undo may take a long time, and supports pressing the ESC key to skip the backup.

2) Added the “Undo does not support big data” option.

15. Improve and speed up some features.