Excel Charts and Table

Hi All,

I have a quick management question. i am a sr. manager with 70 employees under me and 23 locations. Our company is in consumer loan services and lo would love to keep track of each employees and stores performance. I would like to track work by number of loans that each stores put out and who puts it out. for example, Store in Dallas has put 5 loans out but 2 were done by Ivan and 3 were done by Marco. I want to put this in order with calculation at the end on total # of Loans. Also, I want chart to show performance in it too..

How would I do this in Excel…

Thanks in Advance…

Make sure you got all data in 1 sheet.

After that make an table of that data.

After that make an pivot table of that data.

After that make a graph of your data.

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.