Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 14
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A simple way to change several cell refs to absolute ? Jay Excel Discussion (Misc queries) 6 December 11th 06 11:46 AM
How do I copy formulas from 1 wrkbk to another w/o absolute refs Mike Excel Discussion (Misc queries) 1 September 25th 06 04:48 PM
returning absolute cell refs karl41 Excel Discussion (Misc queries) 3 August 22nd 06 11:59 AM
Copying a formula with different sheet refs JG Excel Discussion (Misc queries) 0 April 1st 05 08:51 AM
HELP- Copying a Data Series to Another Graph??? phil6666 Excel Discussion (Misc queries) 1 February 9th 05 01:15 AM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"