Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Count number of items in cell for a category

0

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.   

Answer
Discuss

Discussion

Please post your workbook.
Variatus (rep: 4889) 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: 4889) 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
Add to Discussion

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.

  1. Select the range G2:H9 
  2. From the Data tab select the type of chart you want.
  3. Click OK to create the chart.
  4. 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.
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login