Check Boxes to hide chart data

[txgodfather]

I am trying to create a dashboard that will allow me to monitor my monthly sales, expenses, and profit. I have created three different line charts (one for sales, one for expenses, and one for profit). On each chart, each line represents a year (2003 is one line, 2004 another, etc.). Now I have three charts that are way too cluttered. I want to create check boxes for each year that will hide that years data when unchecked. Every year's data is on its own sheet in this workbook. I am having trouble writing the code for this. I saw this code on the forums, but I don't know how to assign a different sheet name.

Sub Hide()
Rows(4).EntireRow.Hidden = True
ActiveSheet.Shapes("CheckBox1").Visible = False
End Sub

Sub UnHide()
Rows(4).EntireRow.Hidden = False
ActiveSheet.Shapes("CheckBox1").Visible = True
End Sub

Any help is greatly appreciated.

 

[dualhcsniatpac]

You mean making another sheet active? Try something like this maybe??

Sheets("SheetNameHere").Rows(4).EntireRow.Hidden = True

Not even sure if that is the correct way but makes sense to me.