View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Tushar Mehta Tushar Mehta is offline
external usenet poster
 
Posts: 126
Default graphing counted time stamps

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.

On Sun, 22 Nov 2009 06:53:02 -0800, Wolfgang
wrote:

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

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-present
www.tushar-mehta.com
Excel and PowerPoint tutorials and add-ins