Trying to make a Pivot Chart based on Pivot Table row tables.
2014-06 2014-07 2014-08 2014-09 Avg% / Tot$
8.48% 5.15% 5.15% 2.76% 7.50%
21.06% 18.23% 15.79% 15.79% 16.29%
5.07% 5.68% 5.20% 4.85% 5.84%
3.75% 2.65% 2.45% 3.32% 7.02%
3.61% 2.48% 3.87% 4.78% 2.87%
2.34% 3.45% 5.01% 3.09% 2.25%
4.43% 4.21% 4.82% 5.84% 3.44%
14.06% 16.16% 18.85% 20.43% 15.40%
20.06% 7.78% 2.71% 4.36% 14.28%
As you know, the Pivot Chart filter only has the months, how do I do a chart on the Avg%/Tot$?
Bookmarks