Hello I need to make a comparison bar graph dependent on year, building, building condition,and building rating and building type.
The building type is either permanent or temporary. If the building is temp I need the color of the bar to be red, if it is perm, I need the bar color to be blue.
I'm not quite sure how to do this with a conditional statement. I can only have two bars per building.
I've attached an excel file.