Excel Tips
Use the SIGN Function for Up/Flat/Down Icon Set »
August 14, 2023
I want to show if a value is up or down compared to the previous reading. How can I use the poorly-named Three Triangles icon set to show up, down, or flat?
Add Icons to Only the Good Cells »
August 11, 2023
I want to mark only the best (or worst) cells with an icon. Everything else should not be marked with any icon.
Control Values for Each Icon »
August 10, 2023
I applied an icon set. They are adding green checkmarks to cells that are not in the best quality range.
Convert a Table of Numbers to a Visualization »
August 9, 2023
My manager’s eyes glaze over when he sees a table of numbers. Is there anything I can do to help him spot trends in the data?
Shade the Normal Range in a Sparkline »
August 8, 2023
The examples in Tufte’s book would often draw a rectangular box to show the expected normal range for a sparkline. This allowed you to see when the sparkline deviated from normal.
Sparklines Are Not Scaled Together »
August 3, 2023
The vertical scale on the sparklines seems to be wrong. This chart is showing that Chicago and Miami have similar January temperatures.
Create Tiny Charts with Sparklines »
August 2, 2023
I need to create a chart for every row in my data set.