1. Step Chart

The Step Chart feature displays data trends at irregular intervals in a chart based on the specified horizontal (category) axis labels and series values in Excel.

2. Target and Actual Chart

This feature compares target values with actual values in a chart. It can compare one or multiple sets of data series and display the actual values using lines or columns.

3. Bullet Chart

The Bullet Chart feature helps you quickly compare an actual value, a target value, and qualitative performance ranges (such as poor, average, and good) horizontally or vertically. It also supports comparing several sets of data series.

Vertical bullet chart:

Horizontal bullet chart:

4. Thermometer Chart

This feature lets you easily compare a current value with a target value. It also supports displaying the vertical axis as a percentage.

5. Gantt Chart

With this feature, you can quickly create a Gantt chart by specifying tasks, start dates, and end dates (or durations) in Excel.

6. Timeline Chart

This feature enables you to easily create a timeline chart in Excel in just three steps, displaying the chronological sequence of past or future events on a timescale.

7. Color Grouping Chart

This feature creates a column or bar chart and changes the fill color for specific data points based on defined grouping ranges.

8. Comparison Bar Chart

This feature helps you quickly compare two sets of series values in a bar chart. It also supports displaying the differences with arrows instead of bars.

9. Column Chart with Percentage Change

Compared to a standard column chart, this feature creates a column chart and marks the changes between adjacent columns with green rising arrows or red declining arrows.

10. Stacked Chart with Percentage

This feature not only creates a stacked column chart but also adds data labels showing the percentage for each data point.

11. Color Chart by Value

With this feature, you can easily change the fill color of data points based on a specified data range. It works well with clustered column and clustered bar charts.

12. Add Line to Chart

This feature quickly adds an average line or a line based on a specified value to the selected chart.

13. Create Simple Drop-down List

This feature simplifies the process of creating a drop-down list using Excel’s built-in functionality, allowing you to complete it in just two steps.

14. Date & Time Helper

With this feature, you can easily add or subtract years, months, weeks, days, hours, minutes, or seconds from a date/time, and calculate age, date differences, or time differences between two dates/times.

15. Share to

Kutools for Excel 22.00 allows you to share the entire add-in or a specific feature with friends via email, Facebook, Twitter, LinkedIn, and Weibo.

• Click Kutools > Share to to share Kutools for Excel with friends.
• Alternatively, enable a feature (for example, the Navigation Pane) and then click the Share button to share only that feature.

16. Feedback

Kutools for Excel 22.00 allows users to submit suggestions and report operation errors directly to our development team.

1. Formula Helper

The Formula Helper has been greatly improved to help users filter, find, and apply formulas easily.

1.1 Formulas are grouped into 5 categories: Date & Time, Statistical, Text, Lookup & Reference, and Math & Trig.

1.2 15 new formulas have been added:

1. Count days, hours, and minutes between dates
2. Convert days to years, months, and days
3. Convert seconds to hh:mm:ss time format
4. Count cells equal to A, B, or C
5. Count cells with two conditions (AND)
6. Count unique values
7. Count cells with unique values (including the first duplicate)
8. Count the number of values separated by commas
9. Extract the nth word in a cell
10. Extract unique values
11. Extract cells with unique values (including the first duplicate)
12. Extract strings between specified text
13. Index and perform math on multiple columns
14. Find the largest value less than a given value
15. Use SUMPRODUCT with criteria

1.3 Supports filtering formulas in the Formula Helper dialog.

2. Dependent Drop-down List

This feature supports creating 2-level dependent drop-down lists arranged horizontally.

3. Multi-select Drop-down List

When you open the Multi-select Drop-down List dialog, it automatically applies the same settings you configured last time.

4. Drop-down List with Check Boxes

1) When you open the Drop-down List with Check Boxes Settings dialog, it automatically reuses the settings you configured previously.
2) It uses different interfaces for Modify mode and Append mode.
3) It supports resizing the drop-down list form by dragging.

5. Beautify the Normal Distribution / Bell Curve Chart

This improvement enhances the visual appeal of the Normal Distribution / Bell Curve chart.

6. Combine Worksheets with OneDrive Support

The Combine Worksheets feature now supports OneDrive files and folders.

7. Super Filter Scenario Loading

The Super Filter feature now loads scenarios more efficiently.

8. Faster Language Calling

Changed the language calling method to speed up form display.

9. Ribbon Adjustments

Adjusted positions of some features on the Ribbon and updated some feature names and super tips.

10. Other Enhancements

Optimized and improved other features.