toggle data series on/off on chart

**xelhelp** · 02-21-2012, 01:54 PM

Hi,

I am using excel 2007. I have a scatter plot which contains multiple data series. I would like to be able to toggle each data series on/off. Something like a check box next to a chart that lets me add/remove data series from the chart is what I'm looking for. I have attached an example spreadsheet with the chart. chartexample.xlsx

I'd really appreciate any help or suggestions on this.

Thanks

**xelhelp** · 02-22-2012, 07:55 PM

Does anyone have any suggestions?

**Pete_UK** · 02-22-2012, 08:22 PM

The attached shows how you can do this for your 5 curves. I've inserted a new column Q so that the Y values for the graph are now derived from column R. I've copied the Y values into column Q, then put this formula in R3:

=IF($V$35="Y",Q3,NA())

and copied this down. Similar formulae have been put in each block further down the column, but referring to V36, V37 etc.

So, change the values in V35:V39 from Y to something else (N ?) and the appropriate set of curves will disappear from the graph. You can apply similar logic to the other data sets.

Hope this helps.

Pete

**xelhelp** · 02-23-2012, 07:57 PM

this will work, thanks Pete

**Sigmunds_Freund** · 12-08-2021, 03:26 AM

Hello,

I actually came to this forum because a google search brought be to this thread. I searched for the exact same problem. Because I wanted to have checkboxes I edited Pete_UKs file and now you can check and uncheck if you want to see the each graph. Maybe someone else can make use of this. Do people actually still use Excel, or is there now an online tool for everything?

**Glenn Kennedy** · 12-08-2021, 04:23 AM

Sigmunds...

Hi.

It's a forum rule that you start your own thread, rather than "piggy-backing" on someone else's thread. This helps prevent massive confusion arising - which will happen if it is not clear which question is being answered. So please start your own thread and explain your own problem (make sure that, right from the start, you use a meaningful title (NOT things like "help needed" or "urgent problem"... think of the Google search terms that you would use to find the solution).

A picture is worth 1,000 words. An Excel sheet is worth 1,000 pictures. So, prepare a SMALL sample sheet (10-20 rows, not thousands!!!). Make sure there is enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary. Remember to remove ALL confidential information first!!!

The yellow banner about sample worksheets, at the top of the screen tells you how to post a sheet here on the Forum.