Here we are going to create Target Vs Achievement Chart
If we are presenting the data in Chart or Picture It will be easy for analyzing the data
Here we are going to create the pie chart using this data
Now I am going to create the balance figure for achieving the target
We are calculating the data by  subtracting the Achieved amount from Target
After getting the value we are going to create the Pie Chart  for easy understanding the status
For bringing the interactive chart we are using the Data Validation option based on the salesman
For creating data validation go to data ,Select Data Validation, in the list we selecting source of the Saleman
Now we can able to select the salesman through the drop down list
Now we are creating table based on the drop down list using Vlook up Formula
Now we are creating Pie Chart
based on the table
Now we are able to creat chart
Blue colors represents Achievement
Orange represents shortage
With help of format data label we can bring percentage
