Need to create a bar graph with the count for 35 different items. Data stored in 917 cells. Each cell contains a different number of items, between 1 and 35, all separated by commas.
Count number of items in cell for a category
0
Discussion
Please post your workbook.
Variatus (rep: 4544) Jan 15, '20 at 9:04 pm
Sorry, my boss would have a problem if I uploaded the actual worksheet. Hopefully the attached will give you an idea. Saw how to post worksheet when first submitting a question but not how to do it now.
Charlie24 (rep: 2) Jan 15, '20 at 10:02 pm
You have to Edit your question. In Edit mode you have access to the button at the bottom you saw before.
Variatus (rep: 4544) Jan 15, '20 at 11:14 pm
Thank you, will give it a try and let you know results. Appreciate the help.
Charlie24 (rep: 2) Jan 17, '20 at 8:41 am
Answers
0
The attached workbook recreates your "Report Out" report using a COUNTIF function to extract the count. Count criteria are listed in column G.
[H2] =COUNTIF($A$2:$A$7,"*" & $G2 & "*")
It also contains a bar chart created form those data.
- Select the range G2:H9
- From the Data tab select the type of chart you want.
- Click OK to create the chart.
- Move it to the location on the sheet where you want it.
You can drag it click-and holding the left mouse button while the cursor appears like a cross of two-sided arrows. The cursor won't have this shape while hoving over the chart in all positions. Move it around until it does.