79484831

Date: 2025-03-04 20:52:28
Score: 1
Natty:
Report link

Here is a formula that can scale the data exponentially so that it gives an apparent smoother scaling between smallest and largest.

=ARRAYFORMULA(if($E$39:$E$59="",,($E$39:$E$59 * 10^((RANK($E$39:$E$59, $E$39:$E$59, 1)-1)/10))))

In E39 to E59 are the original values. This formula should be placed in F39 which is the cell to the right of the topmost value. It works out the rank position for each value and multiply the original value by this exponent. It loses touch with the original values, but it gives a better looking chart in my opinion.

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Jerome Farnan