Excel main madad chahyee

[sittarah]

Dear Members,

Actually mujhy excel main madad chahee.

Actually main aik chart bnana chahti hon.
Yeh uploaded file mainshock,forshcok aur aftershock ki hai.

Hr main shock k fore/aftershocks hain. main inhain aisay plot karna chahti hon kah agr in main din ka difference hai tou sari date show karay aur x-axis pr date aur y-axis pr magnitude ho. matlab agr pahla main shock dekhain tou iss 24-04-1979 hai aur iss ka foreshock 25-01-1979. jab plot ho tou x-axis pr 25-01-1979 se start ho aur aik aik month ka diffrenec rakhtay hoyay 24-04-1979 ko agla event plot ho.

Issi tarha agr mery paas he din main events majood hain tou aik aik din ka differnce rakhtay hoyay hr din ka event plot ho.

Note hr main shock ki plotting alag alag honi hai


Agr problem ko biyan karnay main koi confusion ho tou plz pooch lain. Aur kindly reply kr dain.

Wsalam.

[imran635]

o ho dear mujhy to khud excel nhn aata ap ki kia help karon

[faisal751]

sorry men b itna expert nahi hon
koi bataey jaldi se mujhy bhi jan'na he

[imran635]

Yar main New hon plz mujhy bata sakty ho k New topic kaisa post krty hain??? mujhy sa posting nhn aa rahe ha, koi msg aa jata ha

[ShahidNiazi]

Sister ap is link ko read keren i hope k a ko info mily gi. http://www.cogniview.com/convert-pdf.../excel-design/

[syar]

Agar m drust samjha hon tu try a simple solution.

1. Delete All Blanks Row
2. Column A ko apne marze ka name dain

3. Use pivot table

Set Pivot Table fields
Report Filter = Year
Axis field = Month
value field = date

ya field apni marze ka mutabiq adjust karlain.Ab aap jab bhe year change karain gi tu plot day aur year k hisab sa change hota jae ga.

ya manual charting kar lain. wese ya Phd kuch lambi nahee ho gai ha?

regards

[sittarah]

charting manual hi honi hai. Lakin masla yeh hai kah year,month, day alag laga column main hain dosra yah kah excel in ka differnce ko kaisay read karay ga.

hr main shock k liye manual charting ho gi. bahter ho ga ksi aik mainshock ko pick kr k us ki plotting as an example kr dain. I shall be very thankful to you.

Nhi PhD ka 3 saal minimum duration hai lakin time iss se bhi zayada lag jata-* -hai.

[justali]

No YEAR M D H M S LAT LONG Z M I EPICENTER N14 Catalogue

Kindly ap in column k full name likh k behjain..

[sittarah]

Number, year, month, day, minute, second, latitude,longitude, depth, magnitude, Intensity, epicenter, region,catalogue