I have a chart created by selecting a range from a table filtered by some values. Now if I change the filtering, the chart changes dynamically. How do I opt out of this behavior, i.e. fix the cells list in the chart?
For example, I have selected A1:A10 range as the source data for the chart. When the filtering is applied, it is actually showing A2,A3,A8. How do I keep the list when I remove the filtering from the table?
