Please help!!

U

UchihaObito

I dont know if its been said but I couldn't find it. I put in number
from 1-20 and 31-36 in Column A. I input other data for column B.
When i tried making a chart the values are shown as 1-26 instead o
1-20 and 31-36. Can someone please tell me how to turn the aut
correction off or however you fix it? Thanks
 
G

goober

Stop automatic corrections
On the Tools menu, click AutoCorrect Options.
To prevent all automatic corrections, on the AutoCorrect tab, clear th
Replace text as you type check box.
To prevent specific corrections, clear the corresponding check box fo
the option.

Taken From Excel help
 
R

Ron Coderre

It sounds like you haven't set your X-Axis labels so Excel is simpl
displaying the ordinal number of the data point.

Try this:

Right-click on your data series
Select: Source Data
Set Category (X) axis labels: (select the range containing 1->26 an
31->36)
Click [OK]

Does that fix your problem?

Regards,
Ro
 
Top