Help needed for sorting the data and plotting graph

[SPV]

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

 

[Guest]

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

 

[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?

 

[Guest]

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