Modifying Combination Chart

[maacmaac]

I am trying to create a combo chart with 3 sets of data. The sets of data are called (1) total inquiries (2) inquires reviewed (3) percentage reviewed.

The primary axes I want to use total inquiries and inquiries reviewed (this is a bar chart). The secondary axes I want to use percentage reviewed (this is a line chart).

I have attached the spreadsheet which is mostly completed. I just can't figure out how to add the line chart for the last item. I am not even sure if this is possible. If any help is appreciated.

Thanks

P.S. My company is still using Excel 2000

[Andy Pope]

Yes it's possible.

Select the chart and then extend the data range down to include the A5:F5.
The columns will move over slightly but you will not see any columns due to the very small values.
Select a column series and you the Up arrow to move through the chart elements. When you select the new series use CTRL+1 to display the Format dialog. From here you can set the series to the Secondary Axis.
Now you should see the columns infront of your existing 2 columns.
Select the series and change the chart type to Line.