Do not display columns on charts where entire column contains all zeros

[Ricky Palmer]

Data range is A5:N9 (so far & will be added to each week)

The Legend contains people on the team's names.  

I do not need to see chart data where the column contains all zeros.  I only want to see columns that have data on my chart.

Is this possible to filter out all of the columns where there are zeros under the person's names?

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 

Dates are in column A

Names are in row 5, col B:T

Data values are in rows 6 & beyond in Col B:N

Example:

Person 1 (in column B)

0

0

0

0

Person 2 (in col C)

0

12

5

4

Person 3 (in Col D)

0

0

0

0

For this example the chart should only display Person 2 since there are zeros in columns B & D.