Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 5
Angry 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?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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!
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by Stepper View Post
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?
Don't hide your data.
__________________
Asobi Wa Owari Da
  #4   Report Post  
Banned
 
Posts: 29
Default

Quote:
Originally Posted by wickedchew View Post
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

Last edited by martincrow : May 19th 11 at 07:51 AM
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart displaying "blank" cells? Brandon[_2_] Charts and Charting in Excel 14 February 18th 10 05:13 PM
Hiding #N/A error (or displaying a blank cell instead of #N/A) Eva Marie New Users to Excel 12 October 3rd 08 08:38 AM
Displaying Blank Cells drvortex Excel Worksheet Functions 4 December 5th 05 02:34 PM
Displaying blank field instead of #N/A Joe Hays Excel Discussion (Misc queries) 4 April 29th 05 01:26 AM
Displaying a blank cell RTP Excel Discussion (Misc queries) 4 December 29th 04 04:23 AM


All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"