Excel 2013 2010 2007 2003

How to create a simple histogram chart in Excel

A histogram chart is often confused with a bar chart because it displays data using bars of different heights. The 'true' histogram chart shows the distribution of numerical data. Each bar of the histogram represents the count of data values within the specified range. See more about different types of histogram charts in Excel.

How to hide the cell values in Excel without hiding cells

Conditional formatting of Excel cells simplifies highlighting values by adding color scales, data bars, spark lines and in-cell icons to the cell. The exact values of the highlighted cells rarely meaningful and may even interfere with the perception of information. Custom cell format allows hiding values of such cells without hiding the cells.

How to create irregular polygon charts in Excel

Many organizations utilize 360-degree feedback (also known as multi-rater feedback, multi-source feedback, multi-source assessment, or 360-degree review), to assist employees in work and social skills development. This process includes gathering employee's subordinates, colleagues, supervisor(s), and manager(s) feedback; and comparing self-evaluation and individual group metrics.

A radar chart for personality assessment test visualization

Today, HR professionals in large companies build detailed personality profiles, which include scores of workplace-oriented behavioral indices of the employee. The behavioral scores cover such areas as leadership, communication skills, interpersonal finesse, empathy, diligence, rationality, analyticity, etc. Here radar charts become especially handy because tables, bars, and lines look cluttered and are hard to analyze for a large number of variables.

How to compare strengths and weaknesses, skills, or performance metrics

Time to time, you need to compare strengths and weaknesses, skills, or performance metrics for people, teams, or companies. The dimensions have different qualitative meanings, and, if you choose a bar chart to plot such data, you need to create a separate graph for each aspect. A much better option is to normalize the data and use a spider chart, which renders multiple axes with the same scale.

How to change comma to decimal point and vice versa in Excel

Because of different standards of different countries and cultures, there is a lot of situations when you need to change commas to dots, decimal points or dots, decimal points to commas in an Excel spreadsheet:

How to reduce ribbon size in Excel

After recent updates, the ribbon in Microsoft Excel can take up to 1/3 of the available screen space. Microsoft Office help tells that you can hide or unhide your ribbon, but you cannot reduce the size of your ribbon, or size of the text or the icons. False! You can change the mode and remove unnecessary white space around buttons, and, thus, reduce the ribbon size.

How to create an axis with subcategories

Excel offers a lot of different tricks to create great informative charts and diagrams. A lot of the useful adjustments related to the axis. E.g., you can hide an axis, use primary and secondary axis, change the presentation of data on the axis, etc.

How to create a step chart in Excel

There are a lot of different pre-defined charts in Excel, but for some types of data, pre-defined charts such as area chart or line chart can look fine but are incorrect.

Different rounding effects in Excel

When you work with digits, it’s crucial how you round them. It doesn't depend on what exactly you are rounding - decimals, thousands, or millions. You can see very different amounts after summing the figures, rounded in different ways: