email out Pivot Chart with one record only

[QuocAnh]

I've Create a pivot chart, then for each page, I want to email it to
specified address, the problem is, the pivot out with other page
information, so someone can read the data of others.

Any idea to help. Thanks much!

 

[Guest]

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.

 

[QuocAnh]

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.

Thanks for your idea!
Do you mean "Tab" = "worksheet"??
But the other problem is, I have hundreds of companies. Do i have to
create new tab for "companyA" then email out this sheet, then delete
this sheet, create another for "companyB" ....

Would you give me more ideas!

 

[QuocAnh]

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.

Thanks for your idea!
Do you mean "Tab" = "worksheet"??
But the other problem is, I have hundreds of companies. Do i have to
create new tab for "companyA" then email out this sheet, then delete
this sheet, create another for "companyB" ....

Would you give me more ideas!

 

[QuocAnh]

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.

Thanks for your idea!
Do you mean "Tab" = "sheet"

The other problem is I have hundreds of "company". Do i have to do it
one by one, create a new sheet for a "company" with its data, then
email this sheet, delete this sheet, then repeate it for the next
"company"??

 

[QuocAnh]

FYI, I use XL2000