If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Graphing daily data
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? |
#2
|
|||
|
|||
Graphing daily data
Use your worksheet to pull the relevant data together into a series. Do the
data manipulation in your worksheet, then the chart plots the series which you have generated in the worksheet. -- David Biddulph "Fozzie" wrote in message ... 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? |
#3
|
|||
|
|||
Graphing daily data
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. -- Thanks, Shane Devenshire "Fozzie" wrote: 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? |
Thread Tools | |
Display Modes | |
|
|