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

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

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

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

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

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