
Originally Posted by
rrucksdashel
I am creating a Dashboard for my company and have 8 charts on top each other in one Excel sheet. I have a question about copying the chart down the page.
When I copy chart 1 down 20 rows to create chart 2, the data ranges are absolute and cannot be set to relative. As such, I have to manually adjust the data ranges of every chart. I have 8 charts for 25 salesmen so I don't want to have to manually reset 200 charts. How can I copy Chart 1 down 20 rows and get the data range to also be reading the data (over to the right) 20 rows down?
Bookmarks