What my chart to exclude 0 data...

M

mrobscure

Joined
Jan 18, 2012
Messages
1
Reaction score
0
Hi

I have a formula to count instances of different text strings:
eg: =COUNTIF(Orders!H2:I60,"The Last Laugh*")

I have then created a chart but I don't want the data with zero instances to be included on the chart.

Anyone able to help?

Thanks
 
Back
Top