mischifous
New Member
- Joined
- Mar 14, 2016
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
Hi everyone,
There must be a tool out there that can help me accomplish this:\
I have a very large set of data that spans over a couple of years. Each day is a row, and there are multiple columns of data. Lets say column A is dates, and then columns B through Z are data.
Lets say I create simple line chart plotting the data in column B over time (column A).
Now lets say i want to be able to seamlessly recreate this chart 25x more times for the data in column C - Z, but over time (ie COLUMN A which is the day data). I want these copied charts to have the same formatting as the original chart.
The reality of the situation is that there are far more than just 27 columns and creating each chart one at a time, and re-referencing the data is incredibly time consuming. This is especially the case when I must change the formatting or data range of my charts, and then must go back and manually do this for all the remaining ones.
I wish I could offer whoever gives me a solution to this money, but I know it's against the forum rules. I know there was a plugin that allowed me to copy paste charts and offset the reference range data really seamlessly, but i have spent months looking for it and can no longer find out what it is called. So any other solutions much appreciated.
Thank you guys for your service on these forums, really appreciate it.
There must be a tool out there that can help me accomplish this:\
I have a very large set of data that spans over a couple of years. Each day is a row, and there are multiple columns of data. Lets say column A is dates, and then columns B through Z are data.
Lets say I create simple line chart plotting the data in column B over time (column A).
Now lets say i want to be able to seamlessly recreate this chart 25x more times for the data in column C - Z, but over time (ie COLUMN A which is the day data). I want these copied charts to have the same formatting as the original chart.
The reality of the situation is that there are far more than just 27 columns and creating each chart one at a time, and re-referencing the data is incredibly time consuming. This is especially the case when I must change the formatting or data range of my charts, and then must go back and manually do this for all the remaining ones.
I wish I could offer whoever gives me a solution to this money, but I know it's against the forum rules. I know there was a plugin that allowed me to copy paste charts and offset the reference range data really seamlessly, but i have spent months looking for it and can no longer find out what it is called. So any other solutions much appreciated.
Thank you guys for your service on these forums, really appreciate it.