I want to have each row in a pivot (each row has a very different measure and therefore scaling) have data bars whose sizes appears in relation to the range of values seen in the row, not the overall pivot table.
If I select the entire pivot and data bars, the scaling is relative to the range of all values seen in the pivot so measures that are by their nature small get de-emphasized even though relative to the row some should be emphasized.
The only way I seem to do this is select individual rows one-at-a-time and then apply the data bar formatting (very cumbersome).
Any options?
Thx
Bookmarks