histograms not counting blank cells

G

GJR3599

how do i get a histogram to accept an input field that has some non-data
fields in it? the fields are mostly blank cells, but the histogram doesnt
like them and wont produce a chart/graph. if that doesnt work, is there
another way to count how many scores fall within specific ranges and then
graph those counts?
 

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

Histogram Question 3
How to count non blank cells with a condition? 1
Generating blank or null cells that the Histogram Data Analysis tool will ignore 2
Histogram Invalid Reference 5
Counting cells by font color 2
Count of visible, non-blank cells only? 8
excel modular sheets subsheets 0
count until blank cell 2

Top