Omit data point from chart if corresponding value is 0

I want to show last 3 weeks open issues against each person.
For last week if the value is zero then corresponding person name should not be shown in charts. Is there any way to do it automatically.
currently iam doing it manually by selecting data source and unchecking manually.

Your description is kind of a brain dump and gives us no clue about what data you have, how it is organized, or what your chart looks like.

It will be much easier to understand your problem if you provide your file. This allows us to see and experiment with your data, layout, formulas, code, and possibly attach a file with a completed solution. If you are looking for formulas to produce a desired result, it helps if you create a mock-up of what you want the result to look like. Otherwise we would have to build something from scratch, trying to guess what you want it to look like.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #1 requires good titles. I have updated it for you this time for the sake of expediency. --6StringJazzer