Quote Originally Posted by snowybell View Post
Wait, i have no experience in google spreadsheets, how do i select the colour?
Yellow fields on the top and bottom of big chart on the left have a drop down arrow with all the colors listed for you to select.

Then feel the white fields witht he name of fruit as lsited to the side and the quantities only, it will do the rest and show you results on the smaller chart to the right.