1 of 1 people found this helpful
We see similar questions on the same sort of behavior regarding bar charts. The grand total bar super-dominates all the little individual bars...
Usually the recommendation is to take grand total off this sheet, create your own grand total in a separate sheet, and then position it on the dashboard below your data sheet. Then you can format it separately, exactly the way you want it to display.
Ok, so in other words there is no direct way to do it, just the work around
No other way that I'm aware of.
That's how I handle it.