How to combine a lot of data in one graph, instead of preparing several ind charts?

Imagine I am trying to compare my selling price with my 20 competitors. The selling price changes on a daily basis.
Is there a possibility to create a graph where all data is present, but where I can choose which competitors I compare at a time? e.g. a dropdown list, or even better some check boxes?

The idea is to make it presentable, since all prices have small differences. I prefer not to create 20 graphs.

Your help is appreciated!

Can you post a sample workbook?

Hi Kristof,

You can combine a dropdown list with an if-function in order to achieve that.
Attached is a simple sample with line chart series.
If dropdown = Yes then Value, if No then no Value.

If you need more chart samples, have a look over here: PIMP MY CHART

Regards

Holger