Hi,

To create a scatter chart you need a minimum of a set of Y values.
Select the row or column of cells and using the chart wizard create a
xy-scatter. With only 1 set of values the chart will default to an
incremental set of x values ranging from 1 to the number of cells in the
Y range.

If you have a set of x values as well then select both sets of data.
If you have your data in 2 columns the best layout for the chart wizard is
Xvalue1 Yvalue1
Xvalue2 Yvalue2
....
Xvaluen Yvaluen

If you still have problems maybe you could elaborate on what options you
think are lacking.

Cheers
Andy

zaka wrote:
i tried to create scatter chart, but was not able to do becaues of lack of
options and assistance. could any one please help me

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info