Chart data reading

Copper Contributor

how to let the chart read the data which is selected only with a specific condition

 

for example, i want the chart to read the data only if the value is greater than zero

1 Reply

Hi Hussein,

 

You shall filter your data source, see for example https://blogs.office.com/en-us/2014/02/04/filtering-charts-in-excel/?eu=true