I sure can. For each Expense column (Salary, Other, and Total Expense) under each Subject I am trying to have each value color coded from highest (Dark red) to lowest (Dark Green) value. I have been able to achieve highest to lowest across all Subjects (Ex. Total Expense in English, History, Math, and Sciences highest (dark red) to lowest (dark green)) but not within each Subject (Ex. Total Expense in English highest (dark red) to lowest (dark green), Total Expense in History highest (dark red) to lowest (dark green), Total Expense in Math highest (dark red) to lowest (dark green), and Total Expense in Science highest (dark red) to lowest (dark green).).
Here is a drawing which hopefully will illustrate what I am attempting to do.
1 of 1 people found this helpful
Couple of things.
Because your logic is not based on value, but based on Rank, I used "Rank" for each expense by subject to color the cell.
From the format setting perspective, it requires let's say 150 steps, which is quite troublesome to show step by step.
Please refer this link o get the steps to achieve this. It's quite troublesome for sure...
I definitely dont recommend my method, I do follow Shinichiro Murakami recommendation using Highlight Tables instead my method. However sometime Business users force use to follow same like their like in excel. For that you can try this.
How about this..?
TEST.twbx 42.7 KB
3 of 3 people found this helpful
Just one suggestion in this case.
You can use place holder "1" instead of "0", then change the aggregation to Min.
And edit axis to fix range from 0-3.
This brings the circle shape's position little bit left in the cell (It set on the position of "1" in range of "0-3".
Great Tip, I will make a note on this.
Thank you to both of you! I was going crazy trying to find a viable solution.