Can I create a single visualization with a double y axis without it grouping my dataset?

I have 2 Excel spreadsheets.

The 1st spreadsheet contains the compliance rate for burgers ate, but isn't just a simple compliance / eligibility formula, so that's why it's in a separate sheet.

The 2nd contains over 100k records and is used to show member-level detail. The member detail shows who purchased a burger (eligibile) and who ate it (compliant).

The problem I'm having is that I cannot plot these 2 datasets on my double y axis visual without 1 dataset being grouped together, whether it be the eligibility/compliance metrics summed by all 4 types of burgers for each restaurant or the 4 compliance rates summed to 1 total rate by each restaurant.

I'm trying to see the "percent of burgers ate" on the first y axis and then the "number of burgers that were not eaten" (a value of 0 for compliant) on the other y axis.

First Spreadsheet:

Second Spreadsheet:

I don't want either of the values plotted to be grouped by Percent of Burgers Ate (for all 4 types of burgers) or the number of burgers that were not eaten (for all 4 restaurants). You can see in the image above the 24 represents a sum of non compliant people across all 4 restaurants.

Expected Outcome: