Select Single Series to Chart

**rigsby** · 10-02-2009, 06:51 AM

Hi.

I've created a line chart, data is diplayed at each value. X axis will run Jan-Dec and y will be 1-5. The chart will show three different data series, i.e Ward 1, Ward 2, Ward 3. What I want to do is be able to click each legend key so the other two data series disappear and only the line showing that particular data remains. Can you help please?

**teylyn** · 10-02-2009, 06:56 AM

Please don't post the same question twice. you can change the title of your original post instead. If you're unsure how to do this, read the forum rules. There's actually quite useful info to be gleaned.

also (again!), check out

http://peltiertech.com/Excel/Charts/ChartByControl.html

it really contains all you need to create a solution for your issue.