Filtering values on Graph

Nishu

In the graph shown below, i need graph to be displayed only for which has values (Test 2 and Test 4) and graph which has 0 value should not display names (Test1 and Test3).

This graph data is pulled by source sheet, where team member updates source sheet on weekly basis. There is a chance, where Test 1 and Test 2 will have some values according to updates. In that case, graph should populate the values for Test1 and Test2. Team member should not use any filters to not to display 0 values. Is there anyway we can do this?

Paul H

You need to make them blank to not show on the chart

Use an IF to check if your formula = 0, if its does then blank, else your formula

Example

=IF(Your Formula = 0, "", Your Formula )