Graphing daily data

[Fozzie]

I am trying to graph daily data for a month in Excel 2007 that groups like
days (Saturdays, Sundays, etc) in the same series, while still showing
individual values and dates. Any ideas on how to accomplish this?

 

[ShaneDevenshire]

Hi,

The secret is, as David pointed out, organizing the data in the spreadsheet,
but how do you do that:

Suppose you data is in the range A1:B100, with dates in column A in the
9/21/2008 format.

1 In cell E1 enter any date - if you want to start the dates with Sunday
enter 10/5/08 or any Sunday, if you want to start with Monday enter 10/6/08.
2. Drag the fill handle down to row 7 - that will give you 7 consecutive dates
3. Highlight these cell and choose Format, Cells, Number tab, Custom and
enter the code DDD or DDDD in the Type box.
4. In cell F1 enter the following formula and copy it down to row 7:
=SUMPRODUCT(--(WEEKDAY($A$2:$A$100)=WEEKDAY(E1)))

Plot E1:F7 with column E as your category axis.