Hello,
I have a huge excel document of quarterly business reports.
Each company having 4 rows of data i want to present in a graph.
Quarterly reports.
https://imgur.com/a/TjQYn
Graphs from data.
https://imgur.com/a/QLCro
The data for the next company is always 9 rows below.
Right now i have to copy the charts and then manually go into each chart and select the data and push it 9 rows down.
Since i will have 460 companies in this list it would take forever to do this manually.
Is there any way that i can copy the charts and then use any VBA to push the selected range 9 rows below.
https://imgur.com/a/QLCro
https://imgur.com/ytVrTNJ
Any help would be much appreciated.
I have a huge excel document of quarterly business reports.
Each company having 4 rows of data i want to present in a graph.
Quarterly reports.
https://imgur.com/a/TjQYn
Graphs from data.
https://imgur.com/a/QLCro
The data for the next company is always 9 rows below.
Right now i have to copy the charts and then manually go into each chart and select the data and push it 9 rows down.
Since i will have 460 companies in this list it would take forever to do this manually.
Is there any way that i can copy the charts and then use any VBA to push the selected range 9 rows below.
https://imgur.com/a/QLCro
https://imgur.com/ytVrTNJ
Any help would be much appreciated.