Chapter 17. 3 Ways to Make Handsome Highlight Tables: Tip 2
Use Colors in Moderation
Depending on your objective or business question, it doesn’t always make sense to use a full diverging color palette in a highlight table.
Notice in the highlight tables created in Chapter 16 that the colors for the values of –$25 and $212 are very challenging to differentiate. These numbers mean very different things to the business—one cell represents profitability and the other represents a loss—yet they are both colored gray because they are in the middle of our diverging color spectrum.
You likely will have only a few cells that are easy to differentiate depending on the range of values in your highlight table. If your business question is to truly identify the highest and lowest values in the dataset, you will benefit from reading Chapter 77. Instead, I often want to know which cells contain positive values and which cells contain negative values. This would be easier to differentiate if my highlight table were limited to two colors: one for positive values and one for negative values.
To make this change, you can either click the Colors Marks Card and then choose Edit Colors or double-click the color legend. Both paths open the Edit Colors dialog box:
Lowering the Stepped Color option to two will show one color for positive values and another color for negative values. You can also customize ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
