Hi all,
I'm struggling to find a solution for this particular scenario I've encountered. Essentially what I want to do is take data from a source table that looks like this:
And map it into a pivot table, which would end up looking like this:
Any ideas how this is done? I have fiddled with pivot table settings for hours but not come close to a solution. I am using MS Office Professional Plus 2010.
(For context: the first table is survey data, and the second table feeds into a chart. I want to be able to update the first table by adding more rows as the survey is completed by more people, and for the second table (and thus the chart) to update automatically. At the moment, I am using several "intermediate" pivot tables (one for each colour) and updating the second table manually.)
Thanks!
I'm struggling to find a solution for this particular scenario I've encountered. Essentially what I want to do is take data from a source table that looks like this:
And map it into a pivot table, which would end up looking like this:
Any ideas how this is done? I have fiddled with pivot table settings for hours but not come close to a solution. I am using MS Office Professional Plus 2010.
(For context: the first table is survey data, and the second table feeds into a chart. I want to be able to update the first table by adding more rows as the survey is completed by more people, and for the second table (and thus the chart) to update automatically. At the moment, I am using several "intermediate" pivot tables (one for each colour) and updating the second table manually.)
Thanks!
