Kutools For Excel Full Version Crack

[Perpetuo Carlson]

v260 [Jan 2, 2022]

- New features

- New handy chart templates:

- Battery Chart: This new feature helps to create a battery chart in Excel with just a few clicks. It is a great visual way of viewing the percentage complete and the percentage remaining for a task. According to the battery chart, you can easily know how far through you are for the task.

- Alternative Progress Bar Chart: Compared with the Progress Bar Chart in the previous versions, this Alternative Progress Bar Chart provides a better appearance to display the progress of multiple projects.

- Alternative Stacked Column Chart: This Alternative Stacked Column Chart shows different series as parts of the same single column bar, which helps to compare the values of the series at a glance.

- Dynamic Pie of Pie Chart: In Excel, you can use the built-in Pie of Pie chart to show the proportions of a whole, but it supports only one series at a time. Here, with the Dynamic Pie of Pie Chart feature of Kutools for Excel, you can easily create a chart with two pies that not only shows proportions of the sum of each row or column in the selected range but also displays proportions of the data in a row or column at the same time. In addition, you can dynamically change the displayed data by changing the selection from the drop-down list.

- Scrollable Line Chart: Usually, when displaying a large amount of data with a line chart in Excel, the points are too serried to observe the data and changes of each data point.

- With this Scrollable Line Chart, you can decide how many rows of data to display in the chart at a time, and click right or left at the scroll bar control to change the data displayed.

- Dynamic Column Chart: Normally, when using Excel built-in to create a column chart for multiple series, all series are displayed in the chart at the same time. If you want to display only one series at a time and dynamically change the series as needed, the Dynamic Column Chart feature of Kutools for Excel can do you a favor. This feature helps to create a dynamic column chart with a drop-down list to display data for one series at a time by selecting the series from the drop-down list.

- Dynamic Ranking Bar Chart: This feature helps to create a scrollable dynamic bar chart in descending ranking order to display only the top N values of a series.

- With this chart, you can decide how many rows of data are displayed in the chart at a time, and click right or left at scroll bar control to change the data displayed, and the displayed data will be ranked in descending order automatically.

- Compare Worksheets: This feature compares two specified worksheets in two different workbooks side by side and marks the differences in the same cell position with different background colors, bottom border colors, or font colors as you specified.

- Configure Synchronization: Kutools for Excel now allows synchronizing its configuration information between devices with a OneDrive Account.

- Improvements:

- Performance improvements

- Rename Worksheets.

- Filename List.

- Combine Rows, Columns or Cells without Losing Data.

- Transpose Table Dimensions.

- Select Cells with Format.

- Select Specific Cells.

- Transform Range.

- Select Duplicate & Unique Cells.

- Searchable Drop-down List

- The Searchable Drop-down List feature adds a Mode group, which allows you to add the searched items in an append mode or modify mode according to your needs.

- kte-26-10.png

- Split Data

- This feature now allows users to specify the first few rows as the title rows of split worksheets.

- kte-26-11.png

- Optimize the layout of the ribbon interface to adapt to Windows 11 and the new Office interface.

- Optimize the ribbon icons to adapt to the HDPI display.

- Other improvements.

- Fixed:

- Fixed: The Microsoft Sign in dialog box distorts in HDPI display.

- Fixed: When the Reading Layout feature is enabled, opening CSV files may get stuck in some cases.

- Fixed: Starting Excel may cause loading file error problem in rare cases.

- Fixed: Other minor bugs.

v25.0 [Jun 10, 2021]

New features:

- Smooth Area Chart: By default, area chart has jagged lines when creating by using Excel built-in feature. This Smooth Area Chart feature can help to easily create an area chart with smooth lines by only several clicks.

- Horizontal Waterfall Chart: The Horizontal Waterfall Chart helps to easily generate a horizontal waterfall chart or a mini horizontal waterfall chart in Excel.

- Interval Label Bar Chart: The Interval Label Bar Chart can generate a bar chart with category labels above the bar which help free up more chart space.

- Stacked Difference Chart: The Stacked Difference Chart feature generates a bar or column chart to compare two sets of data. With this type of chart, you can easily figure out whether the data are growing or falling during a certain period, and know the exact amount of change in the data.

- Price Tag Chart: This Price Tag Chart feature generates a chart looks like a price tag, which acts like a column chart but the appearance is more novel and beautiful.

- Check Box Line Chart: When using a line chart to compare many sets of data, the chart looks mussy because there are too many polylines in the chart. The Check Box Line Chart feature helps to generate a dynamic line chart with check boxes in Excel. You can decide which lines to be displayed in the chart by just checking the corresponding check boxes in order to keep the chart clean and easy to analyze.

- Multi-condition Lookup: This Multi-condition Lookup feature helps to look up values in different columns with 2 or more criteria with several clicks only.

- Data Association: The Data Association demonstrates a real-time filtering of worksheets between two Excel workbooks. After configuring this feature, clicking on any cell in the key column of primary worksheet will correlate the data in secondary worksheet and filter the corresponding data immediately.

- Insert QR Code: The Insert QR Code feature can generate QR codes based on specific cell values easily.

- Drop-down List: This version adds several drop-down list related features for you to handle drop-down list easily.

- Encrypt Workbook: The Encrypt Workbook feature can encrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with the same password at the same time.

- Decrypt Workbook: The Decrypt Workbook feature helps to decrypt a batch of workbooks which saved in the same or different folders in current device or OneDrive with specified password.

- Korean Language Pack: This version supports Korean language now.

Improvements:

- Split Workbook.

- Advanced Sort.

- Split Data.

- Export Range to File.

- Passwords Manage.

v23.0 [Aug 28, 2020]

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

- Progress Ring Chart: 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.

- Percentage Ball 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 chart supports to change border color, background color, and foreground color of the ball.

- Progress Bar Chart: Comparing 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 Progress Bar Chart can create a chart based on the given completion percentage. It also supports to create a chart based on the given actual and target values without figuring out the completion percentages in advance.

- Slope Chart: You can easily create a Slope Chart in Excel to visually show the difference between two categories at two times.

- Threshold Value Chart: 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.

- Difference Arrow Chart: 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.

- Matrix Bubble Chart: This feature helps to create a Matrix Bubble Chart with only several clicks in Excel. The matrix bubble chart represents data points by bubbles in a matrix, which is fit to compare multiple sets of data horizontally and vertically.

- Bar with Bubbles Chart: A general clustered bar chart can only show a set 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.

- Difference Area 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.

- Dot Chart: The Dot Chart uses markers to show data, which looks like the scatter chart. But this chart assigns both X and Y axes with two sets of data.

- Variable Width Column Chart: Different 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.

- Marimekko Chart: The Marimekko Chart compounds multiple stacked columns in a chart, and shows all sets of values across three dimensions.

- Lollipop Chart: The Lollipop Chart slims columns to lines, and adds colorful circles at the end of lines, which makes the point values more attractive visually.

- Multi Series Area Chart: The Multi Series Area Chart compounds multiple area graphics in one chart, and helps us easily compare multiple sets of values easily in the chart.

- Proportion Stacked Chart: The Proportion Stacked Chart can reflect the proportion of each point value in a series with small squares.

- BiDirectional Bar Chart: The BiDirectional Bar Chart places two sets of values at two sides of the Y axis, so that we can compare these two sets of values horizontally at ease.

- Multi Series Histogram Chart: This Multi Series Histogram Chart uses a set of columns to represent a set of data, and combine multiple sets of columns in one chart, so that you can easily distinguish these series.

- Copy Format to Other Charts: This feature will copy the formatting of the currently selected chart to multiple charts of the active workbook in bulk.

- Set Absolute Position of Chart: This feature will move the currently selected chart to the specified position, and resize the chart to specified range simultaneously.

- Add Sum Labels to Chart: This feature will add the sum labels for the currently selected stacked chart.

- Add Cumulative Sum to Chart: This feature will add an accumulated line with accumulated total labels for the currently selected clustered column chart.

- Move X-axis to Negative/Zero/Bottom: This feature will move the X axis to the bottom of the currently selected chart.

- Add Trend Lines to Multiple Series: This feature will add a trend line for a scatter chart which contains multiple series of data.

- Change Chart Color According to Cell Color: This feature will change the fill color of columns, bars, scatters, etc. based on the fill color of corresponding cells in the chart data range.

- Data Form: This feature shows the data in the specified range row by row. In the Data Form dialog, we can read, add, delete, or edit the data in rows.

3a8082e126