PLEASE HELP troubleshoot basic chart functions

[slpgrad]

Hello,

I'm using Excel 2007 to make extremely basic charts. I've done this before on other Excel versions without trouble, but there is something very wrong that I cannot figure out. I set up my simple dataset and go to "insert > chart > pie chart." The chart turns out one of two ways: a) the chart shows up with one data category listed as 100% and the chart is all one color, even when that particular data category is specified in the dataset as 1.2%. And b) the cart shows up with the legend and title in place, but white space where the pie should be. What the heck is going on? I'm setting the data up correctly, because I very occasionally get one chart that turns out right when I follow this same process. However, but most of the time I get these other issues.

I VERY much appreciate any help.
Thank you!
Anne

 

[Excelestial]

Your chart will behave according to its content. If your 1.2% stands among giant percentages or other giant numbers in comparison, then your 1.2% will be so negligible that it won't show up. Sounds like there is another number overshadowing your 1.2%. Additionally, if you're chart isn't showing up at all...is it possible you're hiding the column that contains the charted values?