Selection one of the bar from grouped bars in bar chart
I have developed a bar chart, i have 2 dimensions on y axis (AdmissionType, AdmissionMonth). When i select sheet for two months it shows grouped chart. See scenario1.png in attachment.
Now i want to select only May Month of ABC AdmissionType. But when i am clicking on May it is selecting both May and June months. Basically it is selecting AdmissionType='ABC'. See scenario2.png in attachment.
But i want to select only May month and get only 11 records of May month. It this possible?