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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the weighted average of text that have been given values 1
PowerPoint Embed scroll excel chart and data in powerpoint 0
Exclude certain text from =COUNTA 2
exclude certain data 1
how to count if a cell value falls between two numbers 4
auto-expanding chart- dynamic ranges 1
Multiple arguments 1
COUNTIF Function 4

Top