One column is Provisional Performance Rating and other is Final Performance Rating having values as 1, 2, 3,4,5.
The Provisional Performance Rating and other is Final Performance Rating is different for each employee.
We need to make a Clustered column chart for displaying count of employees i.e Provisional Performance Rating VS Final Performance Rating for each rating.
Since the chart needs to be displayed on a common axis on rating data, now the count for either Provisional Performance Rating or Final Performance Rating is displayed correctly instead of showing both of them correctly hence we are getting wrong data.
The sample final output would be similar as shown below:
So would really appreciate if we could get any idea or help?