Fill in the blank cells in the GapID column. Then, use your data table as
the source for a PivotTable (and PivotChart) -- Data | PivotTable and
PivotChart Report...

In the PT make the Bundle the row field and 'Count of Gap ID' as the data
field. The latter should be the default when you drag the GapID token onto
the Data region of the PT.
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


" 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