GROUP PIVOT CHART

I will need to create a pivot chart according to the serial no. For eg: All102, All101, All103, AIM102,AIM104, AIM103, AIE103,AIE102. I will need to group them in a way that AIM103 and AIM104 falls into the same category, AIM10X and create into pivot chart according to the category. Thanks in advanced.

There's no information about the data or file on which you want to achieve this. If you want to group certain fields, you can add another header in your data, and customize the source data.