ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Copying Charts w/o absolute refs in data series? (https://www.excelbanter.com/charts-charting-excel/169763-copying-charts-w-o-absolute-refs-data-series.html)

TSW632

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