Indicator Dots are used to highlight a value in a spreadsheet cell that is over (or under) a specified value. This can be used to make it easier for the reader to identify values of interest quickly and clearly. Using standard icon sets The simplest option is to apply a standard set of icons in […]
Adding Data Bars to your tables
Data Bars can be used to compare numbers where you need to present information in a table, but a trend or pattern is more easily seen visually. They are a bit like a mini Bar Chart in a worksheet cell. Data Bars can be created from positive or negative numbers, you can specify the scale […]
Creating Heatmaps using conditional formatting
In this context, a Heatmap is a spreadsheet table where the data are visualised using a range of colour. But you should take care. If you overdo it, this technique can increase clutter and reduce the readability of your table, not improve it. Note: This tutorial applies to Microsoft Excel 2016. But you should be […]