The solution doesn't require any VBA code; it relies on named formulas.

If you want the code to create the named formulas, turn on the macro
recorder (Tools | Macro Record new macro...), create the names as
shown in the web page, and turn off the recorder. XL will give you the
necessary code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Hi Tushar
Can you please confirm if I am meant to replace the set ranges with the 2
formula's that have to do with adding additional data.

I seem to be having trouble understanding what and where I am to place the
code plus it doesn't seem to like it in my code.

Thank you for your help.
Noemi

"Tushar Mehta" wrote:

In my case, specifically
Dynamic Charts
http://www.tushar-mehta.com/excel/ne...rts/index.html
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
see pages of Peltier and tushar Mehta - on dynamic ranges.


{snip}