Hello - when using the Col Series chart view,...

slice
(Adam De) #1

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?

(Tony Fader) #2

@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