how to chart question

  • Thread starter Thread starter Jeff Kish
  • Start date Start date
J

Jeff Kish

Hi.
I have some data about failures.

the log file is like this (but really much longer):

app1 03/04/2006 08:51
app2 03/04/2006 09:42
app1 03/04/2006 18:33
app3 03/05/2006 00:14
app1 03/05/2006 00:21
app2 03/05/2006 01:52
app1 03/06/2006 02:51
app3 03/06/2006 08:54

I would like to create some charts but don't know how.

ex:

app 3/4 3/5 3/6

app1 x x x
app2 x
app3 x
=========================================

can someone point me in the correct direction?
I'm guessing I'll have to group the data somehow.
I have lots of data, so I'm not sure the best way to
going about this.
It is not a school assignment.
(I don't think I'll ever go back there I'm too old)
Thanks
 
Hi Jeff -

Put headers on the data, like "App", "Date", and "Time". Create a pivot
table to arrange the data. Select the data, then on the Data menu, choose
the Pivot Table Report command. Go through the defaults, then when you get
to an empty pivot table, drag the Date field to the Rows area, the App field
to the Columns area, and the Time field to the Date area. Now you can make a
pivot chart of this table, or if you don't like pivot charts (like me) you
can make a regular chart, which gives you more formatting and layout
options, but it's not as dynamic. To do this, select a blank cell away from
the pivot table, start the chart wizard, and in Step 2, add each series
individually in the Series tab (using the Date Range tab will produce a
pivot chart).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
 
Hi Jeff -

Put headers on the data, like "App", "Date", and "Time". Create a pivot
table to arrange the data. Select the data, then on the Data menu, choose
the Pivot Table Report command. Go through the defaults, then when you get
to an empty pivot table, drag the Date field to the Rows area, the App field
to the Columns area, and the Time field to the Date area. Now you can make a
pivot chart of this table, or if you don't like pivot charts (like me) you
can make a regular chart, which gives you more formatting and layout
options, but it's not as dynamic. To do this, select a blank cell away from
the pivot table, start the chart wizard, and in Step 2, add each series
individually in the Series tab (using the Date Range tab will produce a
pivot chart).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______
Click to expand...
Thanks Jon. I'll check it out. Appreciate the assistance.
Jeff
 
Back
Top