You create a custom chart template in Microsoft Office Excel 2007. When you apply the custom chart template to an Excel chart in a 2007 Microsoft Office program, the link to the chart data is broken. Additionally, the chart is blank.
To work around this issue, follow these steps:
- Select the chart.
- On the Design tab, click Edit Data in the Data group.