I am using the line chart to display a trend of defects by dept. Some depts has 0 defects but still required to be displayed in the chart.
To do this, I added each dept defects count into the Y-axis.
However, when selected a dept that has 0 value, 2 anomalies occurred:
1. Instead of displaying the selected dept, it shows the first dept. The correct dept is shown is selected a dept with values.
2. The 0 on the line appeared more then 1 as shown in the picture.
Are there alternate settings to resolve the above issues?
Thank you in advance!