Excel interactive chart

Hi,
We have this excel interactive dashboard where on "mouse over"the chart data will change,but I having problem with cell F4(NE)which is not working.

looks like you need to copy your sum formula to cell AD32

Hi,
In the dashboard, the reference cell to the table of all names are shifted of 1 column
e.g : Assam in B4 =Z32 instead of Y32
Hope this helps
Best regards