It would be better to see your workbook Packaged workbooks: when, why, how
Your post raises several questions - have you used "dual Axis" already in your chart - if not that is a route - Dual Axes
If you have used used dual axis there may be a way to reconfigure your chart to have you bars on one chart and lines on another and then use dual axis to merge the 2
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.