Hello All,
I am having a problem that I am sure can be easily fixed, I just can't figure it out!!
I am trying to make this pivot table
<colgroup><col><col><col span="3"><col><col span="7"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>
Into a stacked column chart as they all add up to 100%. But it just keeps coming out all goofy because its a pivot table. I don't want to hard code the data because I will be updating this regularly and want the chart to update as well.
Thoughts??
I am having a problem that I am sure can be easily fixed, I just can't figure it out!!
I am trying to make this pivot table
Count of Rating | Column Labels | |||||||||||||||||||
2012 | 2013 | |||||||||||||||||||
Row Labels | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |
1 | 11% | 4% | 3% | 8% | 6% | 7% | 12% | 10% | 9% | 10% | 12% | 11% | 11% | 13% | 12% | 15% | 13% | 13% | 12% | 12% |
2 | 7% | 4% | 8% | 13% | 6% | 7% | 8% | 8% | 10% | 8% | 10% | 11% | 8% | 11% | 11% | 11% | 11% | 10% | 10% | 12% |
3 | 12% | 10% | 10% | 7% | 11% | 11% | 9% | 10% | 10% | 10% | 12% | 10% | 10% | 11% | 11% | 10% | 10% | 10% | 10% | 10% |
4 | 18% | 15% | 14% | 20% | 19% | 20% | 17% | 18% | 18% | 22% | 19% | 19% | 20% | 17% | 19% | 19% | 21% | 20% | 19% | 20% |
5 | 51% | 68% | 66% | 52% | 58% | 54% | 53% | 55% | 53% | 50% | 47% | 49% | 51% | 49% | 46% | 45% | 46% | 48% | 49% | 46% |
<colgroup><col><col><col span="3"><col><col span="7"><col><col span="3"><col><col span="3"></colgroup><tbody>
</tbody>
Into a stacked column chart as they all add up to 100%. But it just keeps coming out all goofy because its a pivot table. I don't want to hard code the data because I will be updating this regularly and want the chart to update as well.
Thoughts??