Hey everyone,
I'm hoping that one of you Excel Jedis can help me out here, I don't even know if what I'm looking for can even be done. At work, we use a dashboard made from an excel (2003) workbook, which creates a bar graph showing the amount of: interior patrols, exterior patrols, camera tours, etc. We also have another bar graph showing the "recommended" amounts (e.g. - requiring that 6 interior patrols are done in the course of the day). What I would like to know is if there is a way to have the first graph show a red bar for interior patrols, until the number reaches 6, after which the bar turns green. Essentially, this just provides as a quick status check to see what quotas haven't been met for the day. Any help is appreciated. Thank you!
Ryan
I'm hoping that one of you Excel Jedis can help me out here, I don't even know if what I'm looking for can even be done. At work, we use a dashboard made from an excel (2003) workbook, which creates a bar graph showing the amount of: interior patrols, exterior patrols, camera tours, etc. We also have another bar graph showing the "recommended" amounts (e.g. - requiring that 6 interior patrols are done in the course of the day). What I would like to know is if there is a way to have the first graph show a red bar for interior patrols, until the number reaches 6, after which the bar turns green. Essentially, this just provides as a quick status check to see what quotas haven't been met for the day. Any help is appreciated. Thank you!
Ryan
