Hi,

You will need 3 columns of data.
Column A contains x axis labels
Column B contains data with values in the range 0 to 1000
Column C contains data with values in the range 0 to 0.0001

Select all the data and use the chart wizard to create a line chart.
Select the 2nd series, one with the values 0 to 0.0001, press CTRL+1 to
bring up the format dialog. On the Axis tab choose Secondary axis.

If you want a chart type of column then you will need to stagger your
data in order to avoid overlapping columns.
See Jon Peltier's page of links for more information on cluster &
stacked column charts.
http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Cheers
Andy