I've got records in a SQL database. And I want to chart the total number of records by the Product field. The product field has multiple entries in it.

Product field entries can be Cells, Mods, Systems, EEs. Or, it can be a combination of these like: Cells, Mods

 

or

Mods, EEs

 

or

EEs, Mods, Systems

 

or etc...

 

 

I need to chart this by each products and not combination of these.

The Y-axis should contain the Sum, while the X-Axis should contain the 4 entries.

 

Right now, my X-Axis is showing combinations of the Products.

 

How do I go about this?

 

Thanks so much!