Forum Discussion

Copper Contributor

Dec 25, 2017

Chart data reading

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

Diamond Contributor

Dec 26, 2017

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