A chart with 2 datas

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.
 
D

David Biddulph

To plot a chart you need numbers. Use your worksheet to produce the numbers
you want, then you can plot them on a chart.
 
Y

ymcj

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

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

Descenders clipped 0
Remove all formatting charactersf except for paragraph and cr/lf 0
Aligning lines in a chart 4
Aligning lines in a chart 10
How to create a bubble chart with more than 2 variables. 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Non Linear Scatter plot, need to find y value 3

Top