This chart plots data from a closed worksheet. You need to open the source book (Data tab, Manage Connections group, Edit ...