Hi,
Sorry for the delay friends.. I was out of office.
I tried with your suggestions.. even I have got some more ideas from that and the sheet is working fine, too good actually.
Thanks Faseeh, Thanks Atul..
And Thanks Chandoo! :)
Annen
Hi,
I have a quality report, where I want to show the graph of employee's quality & average of others. but the line starts from 1st point of X-Axis, Is it possible to start that line from joint of X-Axis & Y-Axis.
e.g-
100%|
075%|
050%|
025%|____|________|_______|___...
Hello sir,
I'm EXTREMELY EXTREMELY SORRY about it..
Actually the thing is I don't know how to use VB. I am trying to learn it.
We use an AHT sheet in the office(But I cant upload or cant send it to personal email), and there are so many things, which I want to change. I tried to make some...
Hi..
I want to make an AHT (Average Handling Time) sheet. The sheet is to calculate time of the calls taken by executives. Please help me for VB code. Is it possible to calculate time without using VB code?
The columns we will need-
Cust ID........Users........Start Time........Contact...
Hi Narayan sir,
Thank you so much, finally I got it!
Can you please tell me, how you linked that chart to the cell range? I tried it by using OFFSET formula but it worked only once, then it stopped.
please tell me how to use it.
Again thanks for the file.
Thank you so much Dan, Faseeh...
Hey Faseeh,
Both the files are are really awesome. I will surely try with new one.
Thanks!
Atul,
your suggestion is too good, to show details of TARGET & AVERAGE, I'll add another chart. It looks quite better and easy to understand for agents as well.
Thanks for the suggestion dude.
but...
Hi Faseeh,
I checked with your file, Its good but the thing is there is no need to compare the data between Australia & USA. so I simply removed USA field. Now only one Productivity table is there.
I have added one more column in front of Total & Target table, so that you will come to know...
Hi Faseeh,
Actually, its not necessary to have the table in the main tab, we just need to compare the work done by agents (not in the countries, both are different processes). but it would be better if we will have both of the data i.e. table as well as chart to show in detail.
Hi Narayan...
Hi Atul,
Exactly! I want to compare the data, but not between both of the process's.
the comparison between agents of the same process is required & it should be reflected by chart only. The option buttons given in the sheet will order chart to show what exactly viewer wants.
there is no...
Hi Faseeh,
I have uploaded a new file, please check.
https://skydrive.live.com/redir.aspx?cid=884c9a212345bb9a&resid=884C9A212345BB9A!109&parid=884C9A212345BB9A!107
Thanks!
Hi Chandoo & Everyone..
I am completely new here & this one is my first topic.
I have an excel sheet, which we send across the team to show weekly production report. Earlier we were using a simple chart and it was changeable, based on a Combo box (using IF statement).
now my manager is not...