greetings, you'll probably want to create separate tab for each person you
send the chart to. first tab will have data for "company A" and "other"
(which would be the sum of all other companies) and apply same pivot chart
you're currently using to this data; second tab would have data for "company
B" and "other"; third tab would have data for "company C" and "other", etc.