Need help with Combo Chart in Excel

[A_Al]

Hi,
I am writing to seek your assistance with creating a combo chart in Excel. I need to display both numbers and percentages in the chart, with the line chart showing the percentage values and the column chart showing the number values.

I tried creating the chart using the "chart type combo", but I am facing an issue. The line doesn't cross the column to display the cash percentage of the column.

To help you understand the challenge better, I have attached a screenshot to show the idea. As you can see, I want the gray line to be like the green line in the chart.

I appreciate your expertise in Excel and would be grateful for any help you can provide.

Thank you for your time and assistance.

Best regards,

 

[OaklandJim]

If you could post a workbook for me to work with I'll try to assist. Use the link icon above the message area. Or, post your data using Mr Excel's XLBB add-in. See HERE.