Skip to Content
0
Former Member
Feb 24, 2011 at 04:10 PM

Hide an individual chart series but not all of them?

33 Views

I have a combination chart on my canvas showing multiple bars and lines. I also have a Radio Button to toggle a view of what bars and lines show up on my chart. Basically what i'm trying to do is if "Rep Office" is selected, the chart will then hide the "Region" related information (1 bar and 1 line).

So in my spreadsheet i'm just doing a basic IF statement that has the following logic (condition, ifTrue, ifFalse) for each series source cells:

Rep Office Series 1 has this condition --> =IF(RadioButton=RepOffice, Series1=RepOfficeData, Series1=0).

Regional Series 1 has this condition --> =IF(RadioButton=Region, Series1=RegionData, Series1=0).

So if my radio button isn't equal to "RepOffice" then I just point that particular series (which is for Rep Office numbers) to values of Zero. But is there a way to actually HIDE that individual series so it doesn't display on the chart at all? Right now since it's just setting values to 0 if I don't want them to be displayed it's putting the line along the bottom and the key remains in the legend which doesn't look professional. If you need any additional information/clarification let me know, thanks!

Here is a screenshot to help you get a better picture:

http://img20.imageshack.us/img20/4830/asdf1234.jpg