Select series(lines) in a line graph by adding userform with checkboxes on a chart

**aab_489** · 04-15-2014, 09:10 AM

I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?

Thank you in advance for your help.

**Pauleyb** · 04-17-2014, 03:51 PM

I would recommend a pivot chart. Here is a recent post that seems similar to your issue:
http://www.excelforum.com/excel-char...ml#post3647029

**aab_489** · 04-24-2014, 12:25 PM

Thank you for the reply Pauley.

I can do similar operation by adding autofilter to the underlying data and select/deselect series that I want view. But I specifically need buttons on the chart sheet that would represent each series (chart sheet is on a separate tab).

I would be grateful if yourself or anyone can help me implement this.

Thank you.

Select series(lines) in a line graph by adding userform with checkboxes on a chart

LinkBack

Thread Tools

Rate This Thread

Display

Select series(lines) in a line graph by adding userform with checkboxes on a chart

Re: Select series(lines) in a line graph by adding userform with checkboxes on a chart

Re: Select series(lines) in a line graph by adding userform with checkboxes on a chart

Thread Information

Users Browsing this Thread

Similar Threads

Adding ONE OCCURRENCE of the series data label on each line in a line chart - excel 2010

Line Chart: why can sometimes select all series at once but sometimes only one at a time?

All the series lines in the chart are drawn on the same line

[SOLVED] Combine stacked column and line chart w/series lines

Automatically adding Vertical lines after certain points in line graph

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions