Reference the current sheet in a formula for chart data ranges?

Collin10592 Posts 6 Registration date Wednesday July 23, 2014 Status Member Last seen July 29, 2014 - Jul 23, 2014 at 12:59 AM
How can I reference the current sheet in a formula for a chart data range?

I am making a large number of graphs; each one references data on the same sheet, but there are 12 different sheets of data and graphs. They are all formatted the same, so I am wondering if there is a way to use a formula in the chart data range that references specific cells (A27:AI37, for example) on whatever sheet I paste the graphs to; that way I will only have to make them once. In other words, I want to make the graphs on the first sheet and then paste them to the other 11 and not have to re-select the data range for each of them.