Resolved {still not happy though}- Pie Chart causing great anger

So it's funny that with all the advanced knowledge I have with Excel, something as simple as a pie chart is causing me problems. Thus proving I am still a moron and can be dominated by Excel.

Now I have the following data laid out like so:

Single Family 2 Party
63 122 53

Now, when I select these and try to make a pie chart out of them, it gives me a chart with Family & 2 party only... Single is listed there, but it doesn't have a part in the pie.

Why don't single people get pie? I liked pie even when I was single.

Any ideas?

Ok, so I figured out that Excel simply is not recognizing numbers. Period, no matter how I format the cells, I cannot Auto Sum, I cannot add manually with any formulas.

If I delete the cells, (Right click > Delete) it seems to correct it, but wow... What is this?

if you just enter that data in a new workbook and select it and make a pie chart does it work?

i just did that and it worked fine...

EDIT: nevermind. i didnt see your last post. good luck with that :)

Heh, yeah...

These numbers were pasted as text from a PDF file, but Excel makes them so I cannot even convert them to numbers.

God I hate Excel sometimes.

Got it!

I was parsing out the numbers with Left() as so:

Code:

---

=LEFT(C8,SEARCH(" ",C8,1)-1)

---

Which would pull them, but Excel would format them as text, not seeing a value and holding on to that text format as a "I WILL BE FOUND DEAD AND COLD BEFORE I LET YOU USE THESE AS NUMBERS" psychopathic maniac.

I changed the code to:

Code:

---

=VALUE(LEFT(C8,SEARCH(" ",C8,1)-1))

---

It fixed everything.
:/

Because it made me very angry...

I might change the title when I am done being mad, but I doubt it...

I don't care if it was coded that way. The fact was, it was pulling an integer with no spaces or anything. So to not let me change the cell format to number is kind of a joke. If you ask me.

See, what you're doing here is being too serious in what is supposed to be a somewhat funny situation.

Yep, I appreciate the help.

More often than not my posts for help resolve themselves out as I just need to type it out and think about it that way.

Another example:

vb Code:

x = Right("abc49",2)
y = 7*x
msgbox(y)

Would you expect to return 343? Or would you expect to have to define x as an integer and then use CInt to convert it from a string?

It's a bit less obvious when it's in an Excel formula rather than code, but the principle is the same. I guess maybe it could have thrown an error when trying to format the cell as number when the formula outputs text...?



You'll remember it next time.