Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
graphing counted time stamps
7 views
Skip to first unread message
Wolfgang
Nov 22, 2009, 9:53:02 AM11/22/09
to
Is it possible to generate a graph of counted timestamps? I am importing into
Excel a log file and get one column of time stamps, some time stamps are 1
time , or multiple times. The idea is that for each one time stamp on the
x-axis the y axis shows the counted amount of timestamps for this time. I
assume this should be a common problem, but I could not find the answer for
this.
Any help appreciated, Wolfgang
Excel a log file and get one column of time stamps, some time stamps are 1
time , or multiple times. The idea is that for each one time stamp on the
x-axis the y axis shows the counted amount of timestamps for this time. I
assume this should be a common problem, but I could not find the answer for
this.
Any help appreciated, Wolfgang
Tushar Mehta
Nov 22, 2009, 11:21:51 AM11/22/09
to
Create a PivotTable and PivotChart with the timestamp as the row field
and the data field. Make sure Excel uses COUNT(Timestamp) as the
statistic it shows and not SUM(,,,) or some other statistic.
and the data field. Make sure Excel uses COUNT(Timestamp) as the
statistic it shows and not SUM(,,,) or some other statistic.
Regards,
Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins
Wolfgang
Nov 23, 2009, 8:51:01 AM11/23/09
to
Thanks for the fast answer. I never used pivot tables-chart before. I can
create the pivot table, insert the data into the x-axis. But i am stuck where
i have to insert the count formula. Can you point me to a how to for this?
Thanks a lot again, Wolfgang
create the pivot table, insert the data into the x-axis. But i am stuck where
i have to insert the count formula. Can you point me to a how to for this?
Thanks a lot again, Wolfgang
"Tushar Mehta" wrote:
> .
>
Tushar Mehta
Nov 23, 2009, 7:58:05 PM11/23/09
to
Click and drag the timestamp to the data area. If Excel shows you the
Sum(), right click the item in the PT, select 'Value field
settings...' and in the 'Summarize By' tab select the Count option.
Sum(), right click the item in the PT, select 'Value field
settings...' and in the 'Summarize By' tab select the Count option.
0 new messages