Hi, I am doing a pivot table with some abandon rate of product (A,B,C,D)and the target line (let say 5%). I had added an pivot combo chart with a target line.
1.PNG

However, when I filter out two products (ie. B,D) the pivot chart will automatically change to bar chart rather then combo chart.
2.PNG

Can someone suggest a way to fix the chart type as combo type so that the target line will consistently be a line only? Thanks