Prev: Can't change pt. size in a 3-D Format Chart
Next: Blank instead of ""
From: Jon Peltier on 30 Mar 2010 18:52
I think I've done that with a dummy column that contains the name of the
days of the week.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 3/30/2010 3:48 AM, Duncs wrote:
> Jon,
>
> Unfortunately, I tried a Pivot Table and it wont let me get to the
> level of detail that I need. I need the report to show me a sum for
> all Monday's, Tuesday's etc. in the month. The Pivot Table doesn't,
> AFAIK, let me get to that level of detail.
>
> Duncs
>
> On 29 Mar, 18:36, Jon Peltier<jo...(a)SPAMpeltiertech.com> wrote:
>> The easiest way to apply this kind of grouping is with a pivot table.
>>
>> Grouping by Date in a Pivot Tablehttp://peltiertech.com/WordPress/grouping-by-date-in-a-pivot-table/
>>
>> - Jon
>> -------
>> Jon Peltier
>> Peltier Technical Services, Inc.http://peltiertech.com/
>>
>> On 3/29/2010 9:29 AM, Luke M wrote:
>>
>>
>>
>>> You will need to first create a sum of all your data. On each sheet, setup a
>>> range (in the same spot, lets say AA1:AB7)
>>> List the days of the week, and in AB1:AB7, do:
>>> =SUMIF(A:A,AB1,K:K)
>>> Copied down.
>>
>>> Use this as the data for your plot.- Hide quoted text -
>>
>> - Show quoted text -
>
First  |  Prev  | 
Pages: 1 2
Prev: Can't change pt. size in a 3-D Format Chart
Next: Blank instead of ""