excel tracker queries

Gurus ,

i would like your assistance on the attached excel

1. lets say i have three employees, which i need to track their utilization , how can i make it as a graph ?i tried to do it in pivot , as i couldnt make it . any advise  .

2. As you can see , i have provided status as open or closed , how can i change the entire row (where the text is present ) to be changed to red or green , when status is kept closed .

Appreciate your support.

SID
Book1.xlsx
infiniti7181Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
1-  do you want to show how many open cases each indivitual has?  in graph format?

2- i did not understand, you want the entire row coloured by condtional formatting when status is closed it would be green and when status is open then it should be red?  is that correct?


i have prepared the attached workbook for you.

please see and let me know if that is exactly what you are looking for.
Book1.xlsx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Saurabh Singh TeotiaCommented:
You can do something like this in the powerpivot and get the necessary results.. In additional i added this in the field list to give you a desired output..

Saurabh...
Book1-1.xlsx
infiniti7181Author Commented:
Thanks for the reply ..

1. I guess , i can find resource utlization with number of open and closed cases..thanks..
2. Related with color change , i dont want to color the whole cells , only from A till E . could you please advise of it ?

SID
ProfessorJimJamMicrosoft Excel ExpertCommented:
You can go to conditional formatting and change the range to by putting a:e there
Martin LissOlder than dirtCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.