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