The previous message was a mistake (I pushed 'Enter' before I added the reply).
I'm not sure this is what yo want, but...
Assume the data for the X axis is in column A, the data for the bar chart is in column B and the line chart data is in column C.
Select the cells in columns A to C with the data you want to include in the chart.
Click on the Chart Wirard icon.
Select the "Custom Types" tab
Scroll down and select "Line - Column"
Select 'Next" and enter in the remaining information.
It will make a chart (with one Y axis) and two graphs; a bar graph with the data from column B, and a line graph with the data from column C.
Jay
This doesn't actually give me a bar chart though - it gives me a column chart. I need to have the bars horizontal rather than vertical due to the nature of the information I'm charting and the format of the page. What I want to do is precisely what you describe but rotated 90 degrees. But of course you can't rotate charts in Excel.
Oh how I loathe Excel charting.