Showing all choices on dynamic chart using lookup formula

[amphinomos]

Hi,

I've created a simple dynamic chart using a combination of data validation and an index match match formula. Every time the user makes a choice the chart updates with the right info. However is there a way to create a choice where the user can show *all* the choices at once on the chart ?

Dummy.xlsx

Thanks,
amphinomos

[romperstomper]

Do you need to see all the data in the table as well, or just on the chart? If it's only the chart you could use an additional chart and the camera tool to show whichever chart is appropriate.

[Pete_UK]

See attached file. Make your choices using the drop-down in cell K2 (coloured yellow).

Hope this helps.

Pete

[amphinomos]

Thanks Pete. Probably a thing or two I'll learn in the formulas !