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?