Useful Chart for a Construction Manager
Usual parameter which shows the team's efficiency is E/T ratio which is only a fraction of your turnover and therefore when you try charting with a routine XY chart is not visible or not indicative of this trend.
The trick here is to show the E/T on the secondary axis which needs to be communicated to Excel by you. So, you select and delete the Establishment series which is not pertinent. Now you need to move the E/T series to secondary axis. So you select this series and in the format data series Series option choose Plot Series on Secondary axis to get the desired intent.