the numbers will be produced by COUNTIF of open and closed. I just
need to differentiate the defect and CRs


On May 2, 7:15*pm, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
To plot a chart you need numbers. *Use your worksheet to produce the numbers
you want, then you can plot them on a chart.
--
David Biddulph

"ymcj" wrote in message

...



Hi, I'm trying to plot a chart whereby

Status * * * * * * * * * * * *Type
open * * * * * * * * * * * * * *defect
closed * * * * * * * * * * * * CR
open * * * * * * * * * * * * * *CR
closed * * * * * * * * * * * * defect

I need to chart all those defects that are open or closed only not
including CR
I'm using COUNTIF for open and closed.

I hope this makes sense.- Hide quoted text -

- Show quoted text -