Color coding individual columns in column chart and pop up information for each column

Hi guys i have a column graph but i need to have different colors for each bars in the graph that will correspond to column C of data to so that all sunny days data comes up a certain color, likewise raining days and so on. Is it also possible to switch the labels on each bar so that the numbers are on the bottom and the state name is on the top. Finally is it possible to create a pop-up to highlight the corresponding data in columns D,E,F,G for each bar in the graph.
Sorry all for how many questions I've asked but it has been doing my head in to overcome these issues.
Thanks all