Plot data on Y axis without specifying X axis explicitly

Excel has an option to select data from a single column and prepare a chart on the basis of that (Example below ,  It takes the rownum or Index automatically on x axis) , I want to replicate the same...