Problem merging two charts (Scatter Bubble + Line)

[max_pedreira]

Hello,

Hope you're all great!

For the past few days I've been scratching my head and scraping the internet for an answer to a problem that seemed seemingly simple.

What I've been trying to do is combine a scatter and a line graph into one!
Below is what I'm trying to achieve.

Desired Result.PNG

But so far I've been unable to do it...

Below is the data I want to transpose to the graph.
The blue table is for the bubbles: "Sales" for the size of the bubbles, "Discount" for the y axis, and "Level" for the x axis.
The orange table is for the line: "Discount" for the y axis and "Level" for the x axis.

Source Tables.PNG

My goal with this graph is to visually despite which customers fall below the discount threshold for each level (and which don't).

Can someone help me?

Many thanks in advance!

[6StringJazzer]

Welcome to the Forum max_pedreira!

We recommend that you attach a file rather than a picture of your data. This allows us to work with your data without typing it all in. See the yellow banner at the top of the page for how to attach a file.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.

Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/

I have provided the link here as a courtesy because it is your first post.

https://www.mrexcel.com/board/thread...1257298/unread