how to create a chart from the source which does not have explicit numbers

  • Thread starter Thread starter prasanna.hebri
  • Start date Start date
P

prasanna.hebri

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)
 
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)










- Show quoted text -
Click to expand...

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
 
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)
 
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)








- Show quoted text -
Click to expand...

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

Prasanna
 
Back
Top