you would want to take a look at the action tab on the chart properties

http://msdn.microsoft.com/en-us/library/aa964128%28v=sql.90%29.aspx

Around half way down is this sub heading "7. Add a drill-through action on the sales data value" so you get the right box

Then link it to a secondary report which takes in a parameter of which is the value of the bar which you click on, so needs to be the detail from the chart data source for it to drill through properly.