|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
09-04-2008, 05:32 PM
|
|||
|
|||
|
Need better visual
I've got a list of bus routes (35 in all). Using Excel 2007 I average the ridership of each route together to come up with Riders Per Revenue Hour. Then I take the system average number and plot each route separately against that number. I've got four groups, one that is above the system average, one that is above at least 75% of that number, one that's 50% and one that is below the 50% mark. I present this at a county board meeting each month using PowerPoint. I need to figure out the best way to present this, in a chart? or maybe just data bars. I was even thinking of top/bottom ranking, but need to use the averages. This is what the data looks like in two columns. Thanks
 Route Revenue Hr. 1 32.81 2 24.01 3 29.13 4 19.04 5 11.78 10 15.59 20 14.26 21 22.51 30 40.04 31 36.05 33 25.28 40 13.06 System overall Average 23.63 75% of Avg 17.72 50% of Avg 11.82 Ideas for the best way to present the data? I apologize if this is in the wrong forum. Scarames 
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| RATE() function with Visual Basic | Lotus123 | Excel Programming | 1 | 04-11-2008 01:51 AM |
| Combo Boxes in Visual Basic and excel | chris980 | Excel Programming | 1 | 07-23-2007 04:06 PM |
| What version of Visual Basic w/Office 2001 Mac?? | doctormelodious | Excel Programming | 0 | 05-21-2007 02:52 AM |
| Launch Visual FoxPro with Excel.VBA code | ashjj | Excel Programming | 2 | 03-28-2007 08:16 AM |
| Microsoft Visual Basic For Applications Extensibility Library | DCSwearingen | Excel Programming | 2 | 09-26-2006 04:52 PM |
Thanks for helping.
Linear Mode
