However, this removes the data values - i need to exclude the series name as well so that if the data values is 0 neither the series name or the data value is displayed. I've tried to show it in the attached pic.

This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.