Dynamic Chart

Hello,

all the range names are using Offset() and they are a tangle of interwoven, dynamic range names. Start the cascade of dynamic names with at least one range name that refers to a worksheet range. Then Offset from that.

cheers, teylyn

Nope, scratch that.

The problem is the range name CT. It resolves with an error,
because the Countif in the Offset returns a zero,
which is because the range $AO$45:$AO$56 on the first sheet is empty,
which is because the cells AO26 to AO37 which that range refers to, is empty,
which is because the cells U34, U46, U58, etc, which these cells refer to are all empty.

I stopped after that. There may be other range names that have errors.

That is the reason for the error message and the reason why the charts don't work.

Start from the top of your logic and go through things with a fine tooth comb. Ensure that there is always sufficient data so dynamic range names don't return errors.