Pie Chart Displaying Blank
 

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?

Answer: Pie Chart Displaying Blank
 

It sounds like there might be an issue with the formatting or layout of your data. Here are a few things you can try to troubleshoot the issue:

1. Check the data range: Make sure that the data you are trying to create a pie chart from is in a contiguous range with no blank rows or columns. If there are any blank cells in the range, Excel may not be able to create the chart properly.
   
2. Check the data type: Make sure that the data you are trying to create a pie chart from is in the correct format. For example, if you are trying to create a pie chart from a range of cells that contain text values, Excel may not be able to create the chart properly. Convert the text values to numbers and try creating the chart again.
   
3. Check the chart options: When you create a pie chart, Excel will automatically choose default options for the chart. Check the chart options to make sure that they are set correctly. For example, make sure that the chart is set to display data labels or percentages if that is what you want.
   
4. Try creating a new chart: If none of the above solutions work, try creating a new chart from scratch. Copy the data you want to use for the chart to a new worksheet and try creating the chart again. If the new chart works, there may be an issue with the formatting or layout of the original worksheet.

Hopefully one of these solutions will help you create the pie chart you need. Good luck!

Don't hide your data.

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.

electronic signature