Count items by day
 

I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.

Count items by day
 

Actually, I think you can use your data in a Pivot Table if you just add column headings. I'll assume DATE and TYPE.

From the Excel Main Menu: <Data<Pivot Table
Use: Excel..Click [Next]
Select your data..Click [Next]
Click the [Layout] button

ROW:
___Drag the DATE field here
___Drag the TYPE field here

COLUMN: (Leave this area blank)

DATA: Drag the TYPE field here
If it doesn't list as Count of TYPE...dbl-click it and set it to Count

Click [OK]
Select where you want the Pivot Table.Click [Finish].

The result will be a Pivot Table that lists TYPE counts by DATE and TYPE

Example:
Date____________Type___________Total
1/1/2007________Internet_______1
1/2/2007________Call Center____2
________________Internet_______1
1/3/2007________Call Center____1
________________Internet_______1

Does that help?
..
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)




"Amber" wrote in message ...
I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.

Count items by day
 

Extremely Helpful.

I have never to done a chart off of a pivot table. I would like to be able
to show a line graph with one for each Method (call center and internet) with
the date on the x axis and number on the y axis. How can I change this
within the chart on the pivot table?


"Ron Coderre" wrote:

Actually, I think you can use your data in a Pivot Table if you just add column headings. I'll assume DATE and TYPE.

From the Excel Main Menu: <Data<Pivot Table
Use: Excel..Click [Next]
Select your data..Click [Next]
Click the [Layout] button

ROW:
___Drag the DATE field here
___Drag the TYPE field here

COLUMN: (Leave this area blank)

DATA: Drag the TYPE field here
If it doesn't list as Count of TYPE...dbl-click it and set it to Count

Click [OK]
Select where you want the Pivot Table.Click [Finish].

The result will be a Pivot Table that lists TYPE counts by DATE and TYPE

Example:
Date____________Type___________Total
1/1/2007________Internet_______1
1/2/2007________Call Center____2
________________Internet_______1
1/3/2007________Call Center____1
________________Internet_______1

Does that help?
..
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)




"Amber" wrote in message ...
I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.

Count items by day
 

Sorry I got it. thanks anyway.....

"Amber" wrote:

I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.

Count items by day
 

Pivot Charts can be very annoying.

Try this:
Put the TYPE field in the COLUMN section

That should make the chart plot:
DATEs on the X-Axis
Counts on the Y-Axis

The default chart may be a Column Chart. Right-click in the plot area to change the Chart Type.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Amber" wrote in message ...
Extremely Helpful.

I have never to done a chart off of a pivot table. I would like to be able
to show a line graph with one for each Method (call center and internet) with
the date on the x axis and number on the y axis. How can I change this
within the chart on the pivot table?


"Ron Coderre" wrote:

Actually, I think you can use your data in a Pivot Table if you just add column headings. I'll assume DATE and TYPE.

From the Excel Main Menu: <Data<Pivot Table
Use: Excel..Click [Next]
Select your data..Click [Next]
Click the [Layout] button

ROW:
___Drag the DATE field here
___Drag the TYPE field here

COLUMN: (Leave this area blank)

DATA: Drag the TYPE field here
If it doesn't list as Count of TYPE...dbl-click it and set it to Count

Click [OK]
Select where you want the Pivot Table.Click [Finish].

The result will be a Pivot Table that lists TYPE counts by DATE and TYPE

Example:
Date____________Type___________Total
1/1/2007________Internet_______1
1/2/2007________Call Center____2
________________Internet_______1
1/3/2007________Call Center____1
________________Internet_______1

Does that help?
..
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)




"Amber" wrote in message ...
I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.

Count items by day
 

Thank you so much for your help, but I have more......

Can I change the chart to show the percentage of one method to the other on
a different chart? I assume I would need another pivot table, but I am not
sure where to start. If so, How? I am pulling my hair out trying to learn
this.

"Ron Coderre" wrote:

Pivot Charts can be very annoying.

Try this:
Put the TYPE field in the COLUMN section

That should make the chart plot:
DATEs on the X-Axis
Counts on the Y-Axis

The default chart may be a Column Chart. Right-click in the plot area to change the Chart Type.

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"Amber" wrote in message ...
Extremely Helpful.

I have never to done a chart off of a pivot table. I would like to be able
to show a line graph with one for each Method (call center and internet) with
the date on the x axis and number on the y axis. How can I change this
within the chart on the pivot table?


"Ron Coderre" wrote:

Actually, I think you can use your data in a Pivot Table if you just add column headings. I'll assume DATE and TYPE.

From the Excel Main Menu: <Data<Pivot Table
Use: Excel..Click [Next]
Select your data..Click [Next]
Click the [Layout] button

ROW:
___Drag the DATE field here
___Drag the TYPE field here

COLUMN: (Leave this area blank)

DATA: Drag the TYPE field here
If it doesn't list as Count of TYPE...dbl-click it and set it to Count

Click [OK]
Select where you want the Pivot Table.Click [Finish].

The result will be a Pivot Table that lists TYPE counts by DATE and TYPE

Example:
Date____________Type___________Total
1/1/2007________Internet_______1
1/2/2007________Call Center____2
________________Internet_______1
1/3/2007________Call Center____1
________________Internet_______1

Does that help?
..
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)




"Amber" wrote in message ...
I have a list of data where I want to know, by day, how many time different
items occur.

I have tried several possibilities with no luck. I would like to use a
pivot table but my data is not processing correctly.

1/1/2007 Internet
1/2/2007 Call Center
1/2/2007 Internet
1/2/2007 Call Center
1/3/2007 Call Center
1/3/2007 Internet

I would like the pivot table to be split between internet and call center
for each day, so I can plot these on a graph.