Two axis Bar charts in Excel

Hello

Very frustratingly I am trying to plot a simple sales and
no. units bar chart in Excel 2002. For each X-AXIS
category, (a product) I wanted to show the sales revenue
and the number of units sold. As the axis scales are so
different two y axis are required. I initially tried to
use the chart type "line column on two axes", but this
doesn't look quiet right. I then plotted all the data on a
single y axis bar chart, highlighted a data series and
using the "selected data series", axis tab I selected
the "secondary axis option". Rather than re drawing the
chart and re-scaling the selected data series, the bars
per product, were now stacked on top of each other!! Does
any body know how to produce a simple bar chart using two
Y -axis?

Thanks Harvey