Chart with two columns in that are not adjacent to each other

Hi All,

I have a database of data, I have attached a fake as a sample. The cells in the Sample may be empty as I removed all sensitive info, but in my actual sheet it would have data, I left it this format so you know the Cell references.

I am trying to get a chart to visualize this data. The Chart should do the following.
1 -> Link itself to the custom date range that the user will hardcode
2 -> Show Each associates total sales commission
3 -> Show the Total Commission (sum of both associates)

I really can’t figure it out, I do not know what to put for SeriesData in this case, my chart I do myself never works. Does anyone know of a way I can do this?

You’re help is much appreciated, anything helps as I am breaking my head.

Have a goodday.