B
Blue Max
We have selected a preset conditional format to display cell date values as
a data bar based on lowest and highest value. Unfortunately, we want to
associate earlier dates with the longest bar and later dates with the
shortest bar, which is just opposite of the default. This is because
earlier dates translate to smaller values and later dates translate to
larger values.
Other presets include options to reverse the order or effect, but we see no
such option under this configuration for reversing the displayed bars. Does
anyone have some suggestions on how we can achieve the desired effect?
a data bar based on lowest and highest value. Unfortunately, we want to
associate earlier dates with the longest bar and later dates with the
shortest bar, which is just opposite of the default. This is because
earlier dates translate to smaller values and later dates translate to
larger values.
Other presets include options to reverse the order or effect, but we see no
such option under this configuration for reversing the displayed bars. Does
anyone have some suggestions on how we can achieve the desired effect?