Copying Charts w/o absolute refs in data series?

T

TSW632

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

series w/ named range not shown when reopen chart 0
How do you link chart source data when you copy the chart? 1
How to auto-increment data source cell references when copying cha 0
I want chart source data to be relative references, not absolute. 1
Monthly charts do not retail formula row/column 0
Relative vs Absolute referencing of Workbooks 4
Auto-increment data source cell references when copying charts 2
Chart Series using non-contiguous calls in VBA 1

Top