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