| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create line graph with 3 variables?
I work for a church that has 3 Sunday morning services; 8:00, 9:30 and 11:00.
Attendance can range anywhere from 3000 to 300. I need to create a line graph tracking the attendance of each service (preferably all on one graph) comparing 2007, 2008 and 2009 attendance numbers. I see 3 variables: date, time of service, attendance. How do I put the info in excel to get a graph like that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create line graph with 3 variables?
With your data something like this it is reasonblyy straing forward...
8:30 9:30 11:00 Jan-07 873 2690 2260 Feb-07 2610 2414 1385 Mar-07 432 2578 2491 Apr-07 2358 2048 2035 May-07 1402 185 2363 Jun-07 2625 1676 1245 Jul-07 1888 184 1534 Aug-07 2238 322 1688 Sep-07 692 378 1614 .... This generates 3 different series (lines). Things get more complicated if you want a year over year comparison instead of running your time line straight out. -- HTH... Jim Thomlinson "mneely" wrote: I work for a church that has 3 Sunday morning services; 8:00, 9:30 and 11:00. Attendance can range anywhere from 3000 to 300. I need to create a line graph tracking the attendance of each service (preferably all on one graph) comparing 2007, 2008 and 2009 attendance numbers. I see 3 variables: date, time of service, attendance. How do I put the info in excel to get a graph like that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create simple line graph in Excel!!!!! | Charts and Charting in Excel | |||
| Can I create a line graph based on a formula | Excel Worksheet Functions | |||
| How do you create a cumulative line graph? | Excel Discussion (Misc queries) | |||
| How do I create a line graph with x- y axis? | Charts and Charting in Excel | |||
| Is there a program in office to create a line graph? | Excel Discussion (Misc queries) | |||
Linear Mode
