maheshrk81
Board Regular
- Joined
- Jan 5, 2010
- Messages
- 153
Hi All,
I have a one Graph based on a data. Once the fresh data is pasted i refresh the graph and paste that graph to outlook and used to send mail.
But now based on the same data i need to prepare 10 graphs and those graphs will change when i refresh the formula one after another.
Like: Once i select ABC and refresh the data will change as well as the graph. Now i need to copy and paste the graph in outlook and again go back to Excel and change ABC to DEF and refresh now again the data and the graph will change and i need to copy the graph and paste it in outlook. The same type i need to do for 10 graphs.
I there any posibility that i can make it automated. Even if the graph is copy pasted in word or even in excel at one place then i can copy all the graphs in one shout and paste it in outlook.
Thanks!!!
Mahi
I have a one Graph based on a data. Once the fresh data is pasted i refresh the graph and paste that graph to outlook and used to send mail.
But now based on the same data i need to prepare 10 graphs and those graphs will change when i refresh the formula one after another.
Like: Once i select ABC and refresh the data will change as well as the graph. Now i need to copy and paste the graph in outlook and again go back to Excel and change ABC to DEF and refresh now again the data and the graph will change and i need to copy the graph and paste it in outlook. The same type i need to do for 10 graphs.
I there any posibility that i can make it automated. Even if the graph is copy pasted in word or even in excel at one place then i can copy all the graphs in one shout and paste it in outlook.
Thanks!!!
Mahi
