On Feb 6, 7:43 am, john the confused
wrote:
Lets have another go
Try =SUMPRODUCT(--($A$2:$A$11<""),--($B$2:$B$11="red")) to work out the
number for the chart, changing the cell references & colour as required and
chart form that information
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)



" wrote:
On Feb 5, 12:47 pm, john the confused
wrote:
I am not sure what you want - is it a graph of how many yellow etc?

If it is then you can count the number of yellow with
=COUNTIF($B$2:$B$11,"yellow"), and then do the same for each colour and chart
from this information
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

" wrote:
Hi,

I am not very good wit microsoft excel...so any help is greatly
appreciated.

I need to create a chart with below mentioned data in two columns. The
chart should show the number of gaps in each bundle. (i.e Yellow -2,
Red - 4 and Orange - 1). Since the data is in the below format, how
can I calculate the number of gaps in each bundle and make a chart out
of it?

Gap ID Bundle
gap_01 Yellow
Red
gap_02 Orange
Red
gap_03 Red
gap_04 Red
Yellow
gap_05 Yellow
gap_06 Red
gap_07 Red

Waiting for your reply. Thanks in advance!

Prasanna- Hide quoted text -

- Show quoted text -

Thanks John for trying to help me out.

I want the number of Gap ID's for the corresponding colour. I think
your solution will give the value 3 for yellow. But there are only two
entries(gap_01 and gap_05) for yellow under Gap ID. Similarly 4
entries for Red. So in this case, the chart should represent value 2
for yellow, 4 for red and 1 for orange. Can you help me out in this??

Thanks- Hide quoted text -

- Show quoted text -

Thanks a lot John...it worked :-)
Tushar, Thanks to you too..

Prasanna