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. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/902adf5f-fd74-43d3-bb42-bf3be82b489b%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
