Hi MVPs,

I'm stuggleing with formatting an excel pivot table correctly in excel 2007.
Here is what i've got, a pivot table with hours as the values as compared to
the jobsites they are logged at. here is my struggle. I am trying to make
excel display the the chart with data bars so that i know when a jobsite is
on schedule, and when too many hours (compared to the average) are being
spent there. for example at jobsite A, i want the bar to fill in blue until
the expected number of hours is reached. If the actual number of hours spent
increases over the expected number, i want it to begin a different data bar
in red showing how far over expected hours Job A is compared to say job B, C,
D, etc.
the data i am using comes from is a seperate excel table with the colums
EMPLOYEE, JOBSITE, COST CODE, HOURS, DATE.