excel chart - when pasting, link to new data field not the original one

Hey guys,

I'm building a series of charts that feed off data from pivot tables and wonder if I can link the data of the charts to a different/updated range every time I paste? Now it always links back to the origianl range of data.

http://www.mrexcel.com/forum/excel-q...gory-name.html

As oeldere pointed out, this was originally posted in another forumn.

Thanks

Please read the forumrules, especialy the ones about crossposting.

http://www.mrexcel.com/forum/excel-q...gory-name.html

Please do not PM me, it is a public forum.

Hey oeldere,

Thanks for the reminder of rules for cross posting.

Sorry I'm under a bit of pump so get an answer so posted without reading through the rules.

So I assume this is agaisnt the rule of this forumn? If so I can delete the post now.

Regards
Frankximus

Please do not PM me, it is a public forum.

Hey oeldere,

Thanks for the reminder of rules for cross posting.

Sorry I'm under a bit of pump so get an answer so posted without reading through the rules.

So I assume this is agaisnt the rule of this forumn? If so I can delete the post now.

Regards
Frankximus

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.