Create a stacked column chart for all the series. Then, in the chart
select the series you want as a line chart. With it selected, select
Chart | Chart Type... and choose an appropriate line type.

If you want, you can then move that line to the secondary axis.
Double-click the series then select the Axis tab and pick 'Secondary
Axis'.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , "=?
Utf-8?B?UGF1bCBIZW5kZXJzb24=?=" <Paul
says...
I am able to creat a line column graph on 2 axes. That shows $ as columns
and % as a line.

However I wnat the colunms to be stacked colums. Can this be done?