I am trying to create a simple Pie Chart, but when I select the data and select Insert - Pie Chart, the box appears, with the legend and title, but no pie. If I change it to any other chart type, the chart appears, but if I change it back to a Pie Chart, the pie disappears again.

I tried removing the formulas, but the same thing happened.

I tried created a pie chart in a new worksheet using the same data, and it worked, but in this particular spreadsheet that I need it in - it won't work.

This is driving me crazy! Any ideas?