This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Often times what you may consider better indicators of various items, others do not. It is always a good idea to have a way to turn off conditional formatting in whatever program is displaying it. The most obvious I will use here - MS Excel.