Graph excel

johnsrd · February 10, 2014, 1:16pm

Hello

I'm looking to make a graph in excel in relation to the quote I'm making to the BE. I have 3 possibilities, quote pending, won or lost. Can we make a graph with this type of data or do we have to have numerical values?

Thank you.

benoitlf · February 10, 2014, 1:23pm

You'll have to go through cells that count the number of occurrences and use the formula

=NB.SI(zone; "waiting")

johnsrd · February 10, 2014, 1:29pm

Yes it's perfect, thank you for your help

jose-accessa · February 10, 2014, 2:43pm

Hello

If your problem is solved, could you close the question by designating the @benoit answer as the best?

Thank you