A chart with 2 datas

  • Thread starter Thread starter ymcj
  • Start date Start date
Y

ymcj

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.
 
To plot a chart you need numbers. Use your worksheet to produce the numbers
you want, then you can plot them on a chart.
 
the numbers will be produced by COUNTIF of open and closed. I just
need to differentiate the defect and CRs
 
Back
Top