| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
A chart with 2 datas
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
A chart with 2 datas
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. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
A chart with 2 datas
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking Up Datas when Key Values are Identical | Excel Worksheet Functions | |||
| How to interchange datas of 'X' & 'Y' axes in a Line Chart | Charts and Charting in Excel | |||
| how can i change the colour of eg. datas more than 10%? | Excel Worksheet Functions | |||
| Datas from Access | Excel Discussion (Misc queries) | |||
| changing datas when adding row ? | Excel Worksheet Functions | |||
Linear Mode
