Skip to Content
0
Former Member
Feb 16, 2011 at 04:38 PM

How to use a checkbox to toggle visibility of a Bar or Line on a Graph

77 Views

I came across a tutorial but can't seem to get it working properly. Would someone be able to better explain how you can use checkboxes on/off to toggle the visibility of a line or bar on a graph? I know you can do this directly within the graph's legend, but my legend is so large that it doesnt fit on my screen, so I need to take an alternative route.

This is the tutorial i'm referencing:

http://analysis-reporting.blogspot.com/2009/06/formatting-tricks-2.html

Here is a screenshot of my dashboard. I want to code the checkbox to turn visibility on/off of the blue bar, the blue bar gets its values from Row 3 Colums B to F:

http://img266.imageshack.us/img266/3838/testah.jpg

Any help would be greatly appreciated!