Timeline for Copy a chart from one sheet to another using the target sheet data for the chart in Excel
Current License: CC BY-SA 3.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jul 9, 2018 at 18:41 | history | edited | CommunityBot |
added [vba] to 25523 questions - Shog9 (Id=811)
|
|
| Jun 29, 2015 at 14:52 | answer | added | Jon Peltier | timeline score: 12 | |
| Dec 10, 2013 at 13:24 | answer | added | sancho.s ReinstateMonicaCellio | timeline score: 4 | |
| Aug 13, 2013 at 17:32 | answer | added | GGuess | timeline score: 1 | |
| Sep 23, 2012 at 2:32 | vote | accept | Ari | ||
| Sep 21, 2012 at 17:09 | comment | added | Ari | Thanks for your helpful comments. I do have an incredible amount of sheets to copy and I have to revise my data and charts over and over and have to repeat everything multiple times, hence automation is crucial. | |
| Sep 21, 2012 at 17:05 | answer | added | Ari | timeline score: 1 | |
| Sep 20, 2012 at 19:24 | comment | added | Siddharth Rout |
You can use the chart's .SetSourceData to change the source. Give it a try and if you are stuck then post the code that you tried and we will take it form there :)
|
|
| Sep 20, 2012 at 19:16 | comment | added | Scott Holtzman |
perhaps a macro ... Sure there could be a macro. If you would like help with one, please post the code you've tried and we can help much more effectively. However, I would offer that unless you have an incredible amount of sheets to copy, or need to do it over and over again, doing it the way you've found may be best.
|
|
| Sep 20, 2012 at 18:43 | history | asked | Ari | CC BY-SA 3.0 |