Hello - when using the Col Series chart view, I’d like it to display only items where the $ value is greater than 0 and for that I’ve created a virtual Y/N column, however the chart still shows all values and when clicking on a bar it goes to the default Ref view and cycles through ALL the rows in my google sheet instead of just the items = yes (ie: value > 0).
How do I get the chart to show only > $0 items?
@Adam_De Create a slice of your data, then make your chart view point to the slice. appsheet.com - How to use slices - This app shows how to slice your data How to use slices - This app shows how to slice your data appsheet.com
User | Count |
---|---|
46 | |
29 | |
24 | |
22 | |
13 |