mhening
asked on
Excel Pivot table comparison chart
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.
bldgCondition.xls
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.
bldgCondition.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I solved the problem
In my file, I have used pivot tables that allowed you to slice-n-dice the data as you want. The key is to convert the data in a way that Pivot understands. The output (as suggested by you), I think, is very similar to what you have obtained.
ps. I see some differences between your graph and mine especially around "I". Please confirm.
bldgCondition-1.xls
123.PNG