Make the chart with five bars, right click the bar series you want as a
line, choose Chart Type, and choose a line type. Then right click on the new
line series, select Format, and navigate on the dialog until you have a
chance to change the axis to secondary.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"AnnieW" wrote in message
...
I am trying to do something that seems like it should be simple with a
custom
graph, but in trying to build my own custom graph am not seeing how to
really
do any customizing.
I want to make a 2-axis chart, but instead of 1/2 the series being bars
and
1/2 lines, I want to do all bars except for the very last one as a line (4
bars, 1 line).
I'm using MS Excel 2000.
Thanks for any help!
AnnieW