Calling Excel experts... urgent Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through September 16, 2011 » Calling Excel experts... urgent « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Mrhyderabad
Side Hero
Username: Mrhyderabad

Post Number: 9748
Registered: 01-2008
Posted From: 98.221.83.14

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 01:50 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Thanks KB and Twitter..
Don't say you don't have enough time. You have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresea, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein
Top of pagePrevious messageNext messageBottom of page Link to this message

Adj
Junior Artist
Username: Adj

Post Number: 3
Registered: 09-2011
Posted From: 173.70.108.135

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 01:36 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Khaleja:

ante aayana cheppakundane db lo vallaki thelsa enti. anduke cheppa..who cares ani. evadi dabba vadidi. aayana nenu oxford lo chesadu ani aayana meeda post veyyakodada enti. aayana emanna oxford lo chadiva ani buss excel veyyakunda unnada enti.




Post veyi, Kindal cheyaku. His Oxford education is known to many because many members know him personally and may be in touch with him.


Collections lekkalu gurinchi enduku aggravate avadam, naya paisa labham ledu sankalu guddukovadaniki tappa.
Top of pagePrevious messageNext messageBottom of page Link to this message

Khaleja
Junior Artist
Username: Khaleja

Post Number: 953
Registered: 09-2009
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 01:28 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Adj:

Mana goppa manam cheppukunte dabba antaru.
Mana goppa vere vallu chepte adi gurthimpu antaru.

Teda telusu anukuntunna meeku. Irrelevant post is irrelevant regardless of how well you may try to justify.




ante aayana cheppakundane db lo vallaki thelsa enti. anduke cheppa..who cares ani. evadi dabba vadidi. aayana nenu oxford lo chesadu ani aayana meeda post veyyakodada enti. aayana emanna oxford lo chadiva ani buss excel veyyakunda unnada enti.
Top of pagePrevious messageNext messageBottom of page Link to this message

Adj
Junior Artist
Username: Adj

Post Number: 2
Registered: 09-2011
Posted From: 173.70.108.135

Rating: 
Votes: 1 (Vote!)

Posted on Wednesday, September 14, 2011 - 01:26 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Khaleja:

who cares..evadi goppalu vaadivi..I earn 14K per month after tax..who cares...ikkadaki vachindi edo kasepu cinema la meeda posts vesama leda ani..edo kadapafan leg pulling ki thread vesa as today I saw his post on dookudu audio. ofcourse ee thread lo veyyakodadu kani just saradaga vesa excel experts ani unte.



Mana goppa manam cheppukunte dabba antaru.
Mana goppa vere vallu chepte adi gurthimpu antaru.

Teda telusu anukuntunna meeku. Irrelevant post is irrelevant regardless of how well you may try to justify.
Top of pagePrevious messageNext messageBottom of page Link to this message

Khaleja
Junior Artist
Username: Khaleja

Post Number: 952
Registered: 09-2009
Posted From: 98.151.191.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 12:21 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


King:

Jagan shell company ki auditor va J/K




ready cinema lo laaga jagan and gaali idhariki common auditor ni

saele mrhyder thread spoil chestham enduku le..nenu jump
Top of pagePrevious messageNext messageBottom of page Link to this message

King
Side Hero
Username: King

Post Number: 2343
Registered: 08-2008
Posted From: 208.185.201.194

Rating: 
Votes: 1 (Vote!)

Posted on Wednesday, September 14, 2011 - 12:17 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Khaleja:

I earn 14K per month after tax.



Jagan shell company ki auditor va J/K
Pulpfiction Post Number: 16473
amma thodu Jagan CM ayithe swarna yugam guarantee ..
yes i repeat amma thodu ..
Top of pagePrevious messageNext messageBottom of page Link to this message

Khaleja
Junior Artist
Username: Khaleja

Post Number: 951
Registered: 09-2009
Posted From: 98.151.191.253

Rating: 
Votes: 6 (Vote!)

Posted on Wednesday, September 14, 2011 - 12:10 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Mrhyderabad:

Do you know that he completed MBA from Oxford? Do you have any idea on his career accomplishments?

rest mee vignatha




who cares..evadi goppalu vaadivi..I earn 14K per month after tax..who cares...ikkadaki vachindi edo kasepu cinema la meeda posts vesama leda ani..edo kadapafan leg pulling ki thread vesa as today I saw his post on dookudu audio. ofcourse ee thread lo veyyakodadu kani just saradaga vesa excel experts ani unte.
Top of pagePrevious messageNext messageBottom of page Link to this message

Twitter
Hero
Username: Twitter

Post Number: 11599
Registered: 10-2009
Posted From: 151.191.175.208

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 12:09 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Twitter:

-in the field list drag and drop the fields in the Row Labels section, this will show the Tabular representation first.



in this step drag and drop in Sigma values section as well this will give count on each group.
Lets create a corruption-free India

Top of pagePrevious messageNext messageBottom of page Link to this message

Spy_india
Side Hero
Username: Spy_india

Post Number: 5890
Registered: 02-2008
Posted From: 50.47.60.122

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 12:09 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

subtotal funtion unnadigaa

adi use cheyakoodadaa ikkadaa ??
తండ్రీ ..మాటకోసం - కొడుకు.. తండ్రికోసం
భార్య ..భగనికోసం - లక్ష్మన్న.. అన్నకోసం
జనమంతా ..ఆక్రోశం - జనమంతా.. ఆక్రోశం ..జగమంతా ఆక్రోశం!
Top of pagePrevious messageNext messageBottom of page Link to this message

Twitter
Hero
Username: Twitter

Post Number: 11598
Registered: 10-2009
Posted From: 151.191.175.208

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 12:08 pm:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Mrhyderabad:

Yes...



using Xl 2007:

-select the data you want to present in the graph.
-goto Insert Menu > select pivot in the ribbon that will give you PivotTable Field List on the right hand side
-choose the fields to add to report , in your case choose the dates from the unique list of dates.
-in the field list drag and drop the fields in the Row Labels section, this will show the Tabular representation first.
-add the chart now > select column chart of your choice that will put the chart on the xl sheet just beside the summary table.

thats it your are done.
Lets create a corruption-free India

Top of pagePrevious messageNext messageBottom of page Link to this message

Mrhyderabad
Side Hero
Username: Mrhyderabad

Post Number: 9747
Registered: 01-2008
Posted From: 98.221.83.14

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:56 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Twitter:

are you looking for something like this ?


Yes...


Kingaa_bongaa:

Drag and Drop Column B in the Values box below.


Unable to do this step. The moment i click on column B, pivot table disappears..

Please pardon my ignorance :-) I might be doing something wrong...
Don't say you don't have enough time. You have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresea, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein
Top of pagePrevious messageNext messageBottom of page Link to this message

Kingaa_bongaa
Hero
Username: Kingaa_bongaa

Post Number: 14176
Registered: 02-2008
Posted From: 192.189.128.20

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:55 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

I think this is what he needs.


Input
1-Aug-11 1
1-Aug-11 3
1-Aug-11 4
1-Aug-11 5
2-Aug-11 4
2-Aug-11 3
2-Aug-11 6
2-Aug-11 8
2-Aug-11 7
3-Aug-11 6
3-Aug-11 9
4-Aug-11 2
4-Aug-11 3
4-Aug-11 5
4-Aug-11 7
4-Aug-11 5

Output
Row Labels Sum of 1
8/1/2011 12
8/2/2011 28
8/3/2011 15
8/4/2011 22
(blank)
Grand Total 77
Manaki Manam Kingu, Choosevallaki Bongu.
Top of pagePrevious messageNext messageBottom of page Link to this message

Twitter
Hero
Username: Twitter

Post Number: 11595
Registered: 10-2009
Posted From: 151.191.175.204

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:47 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Mrhyderabad:

01-Aug-11 xxxx
01-Aug-11 xxxx
01-Aug-11 xxxx
01-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
03-Aug-11 xxxx
03-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx




this chart is done using pivot based on your data

http://i.imgur.com/vvSFr.png
are you looking for something like this ?
Lets create a corruption-free India

Top of pagePrevious messageNext messageBottom of page Link to this message

Maverick
Legend
Username: Maverick

Post Number: 30310
Registered: 01-2008
Posted From: 204.86.204.207

Rating: 
Votes: 1 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:43 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

>>Do you know that he completed MBA from Oxford? Do you have any idea on his career accomplishments?

Khalej tammud, paccha gaddi taste ela undi?
Who is this DB member?
Top of pagePrevious messageNext messageBottom of page Link to this message

Yodha
Junior Artist
Username: Yodha

Post Number: 489
Registered: 08-2011
Posted From: 64.20.45.178

Rating: 
Votes: 1 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:42 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Khaleja:

calling kadapafan anochu ga


andhuku thammud DB lo lenola ni gokuthav? btw, repu dookudu collections edthav ga ni excel expertism chupistha
Top of pagePrevious messageNext messageBottom of page Link to this message

Mrhyderabad
Side Hero
Username: Mrhyderabad

Post Number: 9746
Registered: 01-2008
Posted From: 98.221.83.14

Rating: 
Votes: 7 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:37 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)


Khaleja:

calling kadapafan anochu ga


bro, filmi , box office records threads lo comedy chesthe oka kaani ilaaanti threads lo comedy enduku personal gaa?

Do you know that he completed MBA from Oxford? Do you have any idea on his career accomplishments?

rest mee vignatha
Don't say you don't have enough time. You have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresea, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein
Top of pagePrevious messageNext messageBottom of page Link to this message

Kingaa_bongaa
Hero
Username: Kingaa_bongaa

Post Number: 14173
Registered: 02-2008
Posted From: 192.189.128.20

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:24 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Excel 2007?

Select Both Columns
Click on Insert (Menu)
Select Pivot Table (first one from left)
Choose ok on the PopUp Window. You will see another Tab opened
On the New Tab, right side, select the check box against Column A
Drag and Drop Column B in the Values box below.
Manaki Manam Kingu, Choosevallaki Bongu.
Top of pagePrevious messageNext messageBottom of page Link to this message

Khaleja
Junior Artist
Username: Khaleja

Post Number: 950
Registered: 09-2009
Posted From: 98.151.191.253

Rating: 
Votes: 6 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:22 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

calling kadapafan anochu ga
Top of pagePrevious messageNext messageBottom of page Link to this message

Kingaa_bongaa
Hero
Username: Kingaa_bongaa

Post Number: 14172
Registered: 02-2008
Posted From: 192.189.128.20

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:20 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Pivot best.
Manaki Manam Kingu, Choosevallaki Bongu.
Top of pagePrevious messageNext messageBottom of page Link to this message

Maverick
Legend
Username: Maverick

Post Number: 30307
Registered: 01-2008
Posted From: 204.86.204.207

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:17 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Group function edo untundi ga 2007 lo
Who is this DB member?
Top of pagePrevious messageNext messageBottom of page Link to this message

Kuyyo_morro
Side Hero
Username: Kuyyo_morro

Post Number: 3059
Registered: 02-2011
Posted From: 66.145.10.30

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:16 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Pivot chart should help.
Top of pagePrevious messageNext messageBottom of page Link to this message

Sonyvaio
Junior Artist
Username: Sonyvaio

Post Number: 62
Registered: 12-2006
Posted From: 208.242.14.200

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:14 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

use pivot chart on Date and get the count on column B
Top of pagePrevious messageNext messageBottom of page Link to this message

Mrhyderabad
Side Hero
Username: Mrhyderabad

Post Number: 9745
Registered: 01-2008
Posted From: 98.221.83.14

Rating: N/A
Votes: 0 (Vote!)

Posted on Wednesday, September 14, 2011 - 11:12 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Urgent gaa oka help kaavali... research chese time ledu...

Let's i have following data...

Column A Column B

01-Aug-11 xxxx
01-Aug-11 xxxx
01-Aug-11 xxxx
01-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
02-Aug-11 xxxx
03-Aug-11 xxxx
03-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx
04-Aug-11 xxxx

xxxx - it could be any text. Issue details

Question: I need to know how many issues are reported on each day....

I need something like this from the above data so that i can generate a gragh for management

01-AUG-11 - 4
02-AUG-11 - 5
etc

any ideas?
Don't say you don't have enough time. You have exactly the same number of hours per day that were given to Helen Keller, Pasteur, Michaelangelo, Mother Teresea, Leonardo da Vinci, Thomas Jefferson, and Albert Einstein

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x88e9648){Movie Clipart}
Show / Hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  


Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: