![]() |
Copying Charts w/o absolute refs in data series?
I have a chart with it's source data to the right of it. The source
data references sumif criteria also within that same bunch of rows. I wanted to make several copies of these rows and chart down the sheet, with a view to changing the sumif criteria and thus having several DIFFERENT charts. Trouble is I can't figure out how to NOT have the copied charts referencing the first chart's source data. Been googling these groups with no success. Can someone give me clue, or better still a solution? Please don't respond with an email, as I am at work and my groups email is sent to my home email. TIA Troy |
All times are GMT +1. The time now is 01:20 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com