Chart This Data in Excel
Today’s challenge is a simple one but has many answers. You will be presented with a small set of data and I would like to see all the different charts that you think are the best. I will post pictures of all the charts submitted next Friday, so please send me a sample of what you think represents the data in the best way.
Data and Request
| Courier | Dis (mi) | Pkg (#) | Price ($) | Pkg (#) | Price ($) |
| FedEx | 5 | 1 | 16.00 | 5 | 80.00 |
| UberRUSH | 5 | 1 | 21.00 | 5 | 105.00 |
| biolab | 5 | 1 | 5.00 | 5 | 25.00 |
| FEDEX | 20 | 1 | 38.00 | 5 | 190.00 |
| UberRUSH | 20 | 1 | 66.00 | 5 | 330.00 |
| biolab | 20 | 1 | 5.00 | 5 | 25.00 |
| FEDEX | 45 | 1 | 60.00 | 5 | 300.00 |
| UberRUSH | 45 | 1 | 141.00 | 5 | 705.00 |
| biolab | 45 | 1 | 5.00 | 5 | 25.00 |
Client Request: “Above is a comparison of the prices of 3 courier services. What the price is at certain quantity of packages and what the prices are at various distances the courier has to travel. I am leaning towards a simple column graph, but I don’t know how to show it so I can pass along the point in a simple manner. Any suggestions? Thanks. ”
Extra Credit
If we add more data points for numbers of packages (Pkg (#)) how would you chart this data? Same or differently?
| Courier | Dis (mi) | Pkg (#) | Price ($) | Pkg (#) | Price ($) |
| FedEx | 5 | 1 | 16 | 5 | 80 |
| UberRUSH | 5 | 1 | 21 | 5 | 105 |
| biolab | 5 | 1 | 5 | 5 | 25 |
| FEDEX | 20 | 1 | 38 | 5 | 190 |
| UberRUSH | 20 | 1 | 66 | 5 | 330 |
| biolab | 20 | 1 | 5 | 5 | 25 |
| FEDEX | 45 | 1 | 60 | 5 | 300 |
| UberRUSH | 45 | 1 | 141 | 5 | 705 |
| biolab | 45 | 1 | 5 | 5 | 25 |
| FedEx | 5 | 10 | 46 | 20 | 666 |
| UberRUSH | 5 | 10 | 152 | 20 | 483 |
| biolab | 5 | 10 | 41 | 20 | 71 |
| FEDEX | 20 | 10 | 220 | 20 | 1468 |
| UberRUSH | 20 | 10 | 652 | 20 | 1742 |
| biolab | 20 | 10 | 38 | 20 | 219 |
| FEDEX | 45 | 10 | 300 | 20 | 1383 |
| UberRUSH | 45 | 10 | 805 | 20 | 6112 |
| biolab | 45 | 10 | 18 | 20 | 224 |
Submitting Your Answers
If you are a subscriber, you can just reply to the email received with your chart sample (So you may want to subscribe for future challenges). Or leave a comment below and the form asks for your email. I can then send you an email on where you can send your sample Excel chart.
If you are interested in additional Friday Challenges, you can find more Friday Challenges here.
Happy Excel-ing!
Steve=True
