Hi,

1. Add a new column to your raw data area
D of W

Enter the following formula and copy it down

=TEXT(B2,"ddd")

2. Plot the pivot table using this new column A as the row field and calls,
column C as the Data field.

Plot this as your row field.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jordan" wrote:

I have a list of calls we recieve to a call center. I'm trying to figure out
how many calls we get on each day of the week. ie: Monday, Tuesday etc.

I can formatt the date to show MON or TUE but when I try and use the
informtion in a pivot table it still looks at the date Jan 12, formatted as
"MON" as a unique day. I want all the Mondays to be added together.

Any help will be appreciated.

Jordan