Hello,

I try to create a multiple a chart based on three columns and a variable nb of columns where the columns are the X axis

a1 b1 c1
bbb 4 5 7
ccc 5 6 4
ddd 3 5 3


To do that i create a dynamic ranged name and put it in the Range field in the chart wizard. The problem is after doing that, the ranged name becomes an usual static range address. Is there a way to keep the cahrt linked to the Named range instead?

Thanks a lot for your help


Avi Benita 054-4660641 wwwAvi Benita 054-4660641 www.avibenita.com