I have data grouped by Year, then by Month in an Excel 2010 pivot table, like so:
* 2008
** Jan
** Feb
** ...
* 2009
** Jan
** Feb
** ...
One of the value columns is a sum value. I have the "data bars" conditional formatting applied, and when I collapse one of the year groups, the scaling of the uncollapsed rows gets messed up because the sum for one year is so much bigger than any individual month.
* 2008 923,232,424 (max data bar)
* 2009
** Jan 12,345,567 (very short data bar compared to the 2008 total)
** Feb 10,245,981 (hard to notice visual differences between Jan and Feb for 2008)
** ...
Is there a way to have conditional formatting specifically exclude the collapsed year grouping when applying conditional formatting?
