Two horizontal axis to represent count & percentage?

Hello excel Pros,

I created a simple PivotChart whose Axis (Categories) is individual Sales Reps.
The values correspond to one set of data shown in two ways: A count of the number of contacts as well as show a Percentage of Grand Total.

2023-07-21 20_36_42-Q2 inbound funnel analysis.xlsx - Excel.jpg


The problem I am having is with the horizontal Axis of this chart.
While the count shows well, the percentage bars are tiny. I have no idea where to adjust this scale so that those can in fact be visible.
Is it possible to have a secondary horizontal Axis with percentages?

Thank you,

Hello Andy

Thanks for the suggestions.
A Combination chart makes absolute sense.

So I tried that, but I am having somewhat of a similar issue where the percentage Axis has huge numbers.
It extends all the way to 1200,00%

Attachment 837448

I tried changing the Format Axis options, to have have a Maximum of 10 (instead of 120)
Attachment 837449

But the problem with that, is that my bars then get cut off and the
Attachment 837451

Andy
Those were just screenshots. You can disregard the screenshots.
The information I wrote is the key information.

Find the screenshots bellow.

Hey Andy

Yes that was the problem.
I was able to fidget with the chart settings and got it to work correctly. Thanks

It you use Column chart then you can change one of the series to Line and have a combination chart
If you must have bars then you will need to generate 2 more series, so each axis has 2 series on it. One of the series pair will have a value the other not.
You also need to alternate which of the pair has values, otherwise the bars will still overlap each other