Remove 0 value from bar charts

Pamela Wagner
Pamela Wagner ✭✭✭✭✭✭

I have a bar chart where the source data must contain all departments whether they have a value or not (as they change over time). How can I set the chart that it will not graph 0 values and only chart those that do have values?

Answers