 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2007Help needed for sorting the data and plotting graph
Hi All, I am a newbie to the excel world. I have requirement of analysing some data that I will obtain from symbian profiler. I will be having a .txt file with values seperated with tabs so that it can be directly open in excel. In that I have around 25 colums, first being sample interval and rest are having data. My requirement is to plot a graph against the sample interval with data from 2 colums. I can specify the column name for plotting purpose. Once I plot the graph I should be able to calculate the average value of one series for those interval in which the other plotted series is crossing some thereshold value. Can any body help me... Thanks and regards, SPV The first step would be to do Data > TextToColumns > Delimited > Tab.....on column A to break the data out into columar fashion. Then you can proceed as normal to create the chart(s). hth Vaya con Dios, Chuck, CABGx3 > Hi All, > I am a newbie to the excel world. I have requirement of analysing some [quoted text clipped - 9 lines] > Thanks and regards, > SPV Hi HTH, Thanks for your info. I am not having any issues in opening the txt pad in excel. Issue is to find out the name of the colum that i need to plot from the available threads. Then to find out the data values of a particular column in which values cross a threshold.. Then to plot the same with the other column and then calculating the average.... Can I send you a mail seperately with a template sheet? > The first step would be to do Data > TextToColumns > Delimited > Tab.....on > column A to break the data out into columar fashion. Then you can proceed as [quoted text clipped - 19 lines] > > - Show quoted text - We can try..........I don't have a lot of time available these days but may be able to help some. You can send it to my home address, I'll look at it this evening. croberts at tampabay dot rr dot com Vaya con Dios, Chuck, CABGx3 > Hi HTH, > Thanks for your info. [quoted text clipped - 30 lines] > > > > - Show quoted text -
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.