chart presentation issue

Hello friends
I would like to explain you my requirement.
I have a sheet with 15 employee and their monthly based information,As you can see in attached file a red box with a main heading with 2 sub columns have the information of trips + commission, now i would like to representation sub columns also in the chart but it gives me only commision information only ..

any idea , how can i represent this clearly in the chart because i have other 2 tabs in same way only..
Thank You111.png

do you mean something like this?

merged.jpg

next time attach excel file not a useless picture