Dynamic char using offset and named range.

[Geir Hogstad]

Hi,

I am trying to make a dynamic chart, using the Office function. 

The offset function and named value works, but I can not manage to get it correct into the chart. 

Excample file is attached.

Best Regads

- Geir

[#2]

@Geir Hogstad 

Approach is here Dynamic Charts Using Dynamic Arrays - Peltier Tech

I tried to modify a bit in attached

[#3]

Thank you Sergei, but it looks like ypu got the same prolem as I did. The range for the diagram deos nor change if the the dynamic array change, eg a new customer or a new product is included in the table,

/Geir

[#4]

@Geir Hogstad 

Not sure I understood. Let say we have initial set

Let me change customer name

or add one more - they are all here