Thread: Problems creating a graph

Hi guys

not sure if this is possible, but i am trying to create a graph but i am struggling

what i want is,

lead outcome up the y axis “lead loaded, no contact made, contact made etc”

lead source across the x. Lead source is “ branch referral, inbound enquiry etc”
and a colour to identify the three different people . people are Amanda , bill and Debbie

Hi,
You will find attached a solution of chart
Sheet Table contain your data with rearrangement
Sheet PT_PC contain a pivot table and a pivot histogram chart which is conform to your wishes except the manager colour
Sheet PT_PC2 contain a pivot table and a pivot bar chart which is for my side more effective
You can play with the different fields to make your choice
Hope this will helps
Best regards