Scatter Plot with Filter option

[H.H]

Dears,

Could you kindly help me to plot X & Y columns using Scatter plot
with an option to have filter to select any value from Column A

 

[vletm]

H.H
You could continue from this ...

 

[GraH - Guido]

Same deal as vletm , but with slicers on the table as alternative to use filters.

 

[H.H]

Dear Vletm,
could you kindly share in steps how did you create the chart

 

[vletm]

H.H
1) open Your file
2) select columns B & C
3) select 'Scatter' from 'Charts' >> You'll get chart
4) select one-by-one those 'C's and <delete>
5) select 'Gridlines' from 'Chart Layout'
6) select 'Vertical Gridlines' -> 'Major Gridlines' >> You'll get Major Gridlines
... modify other settings as needed in Cairo

 

[Peter Bartholomew]

Hi Guys, I learnt something from your replies! It shows that I have never been a data analyst. The only thing I knew about the regular filter was Ctrl+Shift+L to switch it off to ensure my worksheet layout remains as I intend it (once or twice over the years I have used advanced filter extract).

Your approach is definitely more relevant to the problem than my formula-based strategy. I am looking forward to dynamic arrays though and assume the FILTER function will make things so much simpler.

p.s. What I learnt was that the filter operates on the chart as well as the table.

 

[GraH - Guido]

@Peter Bartholomew , it is working because of standard chart settings in the data series.