There is no data in Excel Pie Chart

[Tarani]

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.

[JyotiT]

Are you hiding the data in Excel. You must not do that. It is recommended that you must keep the data somewhere below or you can reference the data to chart from different sheet also.

[Go!pee]

The order in which data series in pie charts are plotted in Office Excel 2007 is determined by the order of the data on the worksheet. For a different perspective, you can rotate the pie chart slices within the 360 degrees of the circle of the pie chart.