I wish to create a combination bar/line chart using five columns of data -
four to be bar on the primary y axis and one to be line on the secondary y
axis. The chart wizard defaults to three bar and two line. Double clicking on
the line chart in question brings up the format data series dialog box and
allows me to change from seconary to primary axis. However this is still a
line chart and not a bar chart. Can anyone help?