I have 1 column with values. I want to make a chart (pie) and serapate the values eg. 0-100 (count 10 values) 100-1000 (5) etc.
I have 1 column with values. I want to make a chart (pie) and serapate the values eg. 0-100 (count 10 values) 100-1000 (5) etc.
Post a workbook please and indicate the results in the data.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I found a solution using the countif function.