Only Include Rows with Data in a Bar/Column Chart

Jacob Adams

I am looking for a way to only show rows that have data or are non-zero in a bar chart like the pie and donut charts do. I have a list of people with counts for how many rows they have assigned to them on a master sheet. I want to have multiple dashboards (one per manager) that shows the number of assigned rows to each person and will have a separate "Counter" sheet, that holds this information, to power each dashboard. I have my data correct and the chart made, but it shows all of the people instead of only the people that have data in their cells and it is messy looking because of all of the rows without data. If needed, I can delete all of the people who are not under the corresponding manager and solve the problem that way, but I would prefer to keep them to make duplicating the sheet for each manager easy. Thank you for your help!

L_123

post the information to separate reports, then build the charts off the reports. Somewhat tedious, but the easiest way I know how to do it.

Paul Newcome

Use an IF statement. I do this all the time. It works whether you are using a formula or not.

 

=IF(original formula or data > 0, original formula or data)

 

This will populate the cell for anything over 0 and leave all 0's as blanks.