PDA

View Full Version : Excel Problem

caffy
22-04-2004, 11:37 AM
Hi,

In the middle of doing an assignment - using Excel.

I have a problem with autocorrecting - whenever I type in a number like 1-15 (to represent 1 out of 15) or 1/15, it keeps autocorrecting it to Jan-15. Other numbers like 6/15 or 6-15 change to June-15.

How do I change this? I need the data to be in the fraction format, so i can make a pie chart.

On another thought - How do I make a pie chart? I have data of ethnicity, like Chinese, Korean, NZer, Tongan etc. Need to put that into a pie chart, like showing the proportions etc. What I've been doing is highlighting the ethnic group data, and making a pie chart from that. but it does not work? This is why I have reverted to putting it into fraction form (Chinese = 6/15 where 15 is the total number of data I have, and 6 is the number of sample that are Chinese), and hoping it works, but the autocorrecting is stopping me from doing this.

cheers,
caffy

22-04-2004, 11:54 AM
>
> On another thought - How do I make a pie chart? I
> have data of ethnicity, like Chinese, Korean, NZer,
> Tongan etc. Need to put that into a pie chart, like
> showing the proportions etc. What I've been doing is
> highlighting the ethnic group data, and making a pie
> chart from that. but it does not work? This is why I
> have reverted to putting it into fraction form
> (Chinese = 6/15 where 15 is the total number of data
> I have, and 6 is the number of sample that are
> Chinese), and hoping it works, but the autocorrecting
> is stopping me from doing this.

Hi Caffy

I' m a rusty with charts but to start with you need to use whole numbers not fractions (Chinese = 6). To make a chart, highlight the data you want in the chart and click on the chart icon on the standard toolbar, select pie chart and follow the wizard from there.

If i have got this wrong I am sure someone will correct me