S seriously_tho New Member Oct 14, 2014 #1 So I have a column with categories & a column with data. I need to know how often the data falls into those certain categories in a chart/graph etc. This seems like it'd be really simple and yet I'm stumped... Thanks in advance Attachments spoke length chart.xls 30.5 KB · Views: 4
So I have a column with categories & a column with data. I need to know how often the data falls into those certain categories in a chart/graph etc. This seems like it'd be really simple and yet I'm stumped... Thanks in advance
Smallman Excel Ninja Oct 14, 2014 #2 Hi Seriously_tho Just add a pivot table to your data and attach a chart to the pivot table. It is simple and it works. See example attached. Take care Smallman Attachments spoke length chart.xls 42 KB · Views: 6
Hi Seriously_tho Just add a pivot table to your data and attach a chart to the pivot table. It is simple and it works. See example attached. Take care Smallman
S seriously_tho New Member Oct 15, 2014 #3 Thanks, will investigate that tomorrow. Discovered the COUNTIF function today which sorta worked.