Check box Chart - How to hide/show names

**pauldaddyadams** · 05-19-2008, 02:33 PM

Hi,

I have come across the attached spreadsheet and I have created my own from it.

However i would like mine to also display or not display the date label on the chart but I don’t know how to do it from the explanation given.

E.g if the box is checked it will display the line on a graph and importantly display the category name - e.g. City Hall, first donuts etc. If its not checked the graph and name is not displayed.

The link is: http://www.processtrends.com/pg_inte...checkboxes.htm

Any help of how to do it or to just point me in the right direction would be appreciated.

**oldchippy** · 05-19-2008, 04:53 PM

Hi,

Have you tried clicking on the tick mark, once - turn on, again - turn off

**pauldaddyadams** · 05-19-2008, 06:02 PM

Hi,

The spreadsheet attached works fine. The one i have created also works however i only want it to display the series name on the graph if the check box is clicked.

On mine each of the series is permantley visable on the graph unlike the attachement.

Any thoughts?

**Andy Pope** · 05-20-2008, 04:45 AM

To remove the series from the legend you would need to hide the data and have "Plot visible cells only" enabled.

**pauldaddyadams** · 05-20-2008, 05:15 AM

Hi,

I have tried that but it still didnt work

I have attached the spreadsheet I am working on...

I need names not to show in the graph if the corrosponding check box is unticked.

**Andy Pope** · 05-20-2008, 05:26 AM

How did you try hiding the data?

Select row 6 and Hide it. This will remove the series "Number of New Customers" from the chart and legend.

How you current have things set up this will of course hide the checkbox and original data.
To do this with check boxes you will need to use code to apply filtering.

Also in you chart data amend the formula to use NA() instead of zero.

=IF(S6,E6,NA())

**pauldaddyadams** · 05-20-2008, 06:13 AM

Is there not a way to do it without code? In the example they didnt use code.

Its this bit thats unclear to me

Step C - Show Series Range Names- Since our approach is to show the data series if the User checks the checkbox or to show blank series if the checkbox is unchecked, we give range names to the checkbox True/False linked cells.

Step D - Plot Series Formulas - Our final data organization step is to create the plot series range names, one plot series name for each source data series. We want the plot series to point to the source data range if the User has selected the checkbox or to point to the blank series if the User has not checked the box.

**Andy Pope** · 05-20-2008, 06:21 AM

In the example they don't use a legend either.

The formula approach based on the checkboxes will remove the data series points. It will not remove the item from the legend.

So yes code is the only way, unless you create your own legend.

**pauldaddyadams** · 05-20-2008, 06:49 AM

I have now deleted the ledged.

Then when I select each line on the graph, then format and apply the series names is there any way I can get this name to appear only once. At the moment it applies the series name at every point of the graph.