I have repeatedly tried different types of information with one x-axis and one y-axis variable and tried to draw it in excel on xy scatter. Repeatedly it ignores my y axis information. i.e. It highlights the x-axis stuff and just puts y=o for everything on y!!.
I went into the formating and found out that the Series Y Value is blocked on ={1} unlike the Series name which says series range next to it or the Series X Value whic also says Series range. This is more clearly put in the image here:
http://i48.tinypic.com/651lhf.jpg
Plz help me i have to hand in a physics report soon and really need graphs!!!
Thans in advance! 😀
You can make Excel use the dot . decimal separator without changing what the rest of Windows uses.
Click the Office button (top left)
At the bottom click Excel Options
and in the dialog box that opens select the Advanced Options tab
Remove the check (tick) from the box labeled ‘use system separators’
Put a . in the decimal separator box and a , in the thousands separator.
Click OK
(I have never used this, so I can only guess that it will work !)
Good luck
Close Excel.
Open Excel
In the new workbook, this time select cells C1 to D14
Right click and format as General
Enter new whole numbers only – 1, 2, 3 etc.
Select the cells again
Format as number with 2 decimal places.
Create a scatter chart from cells C1 to D14
Enter your numbers as a formula =1.5/1 instead of 1.5
Do not copy and paste – these numbers must be entered from the keyboard.
What is your default date format in windows.
In control panel look in regional and international settings and post short and long-date formats.