Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email out Pivot Chart with one record only
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
email out Pivot Chart with one record only
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
email out Pivot Chart with one record only
On Oct 30, 12:36 am, mwam423
wrote: 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
email out Pivot Chart with one record only
On Oct 30, 12:36 am, mwam423
wrote: 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
email out Pivot Chart with one record only
On Oct 30, 12:36 am, mwam423
wrote: 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"?? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
email out Pivot Chart with one record only
FYI, I use XL2000
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating Pivot Chart / Changing Pivot Chart data range | Excel Discussion (Misc queries) | |||
Email distribution of Access Record | Excel Discussion (Misc queries) | |||
how to add a record to a pivot table | Excel Worksheet Functions | |||
How do I email just one record from an excel database. | Excel Discussion (Misc queries) | |||
Record Pivot table Macro | Excel Programming |