Help with creating a bar chart

I’m stuck when creating the following 2 simple bar charts. 

1. A bar chart that clearly shows the average revenue per ECONOMY car versus the quarter for 2015. 

2. A bar chart that clearly shows the average revenue per PREMIUM car versus the quarter for 2015.

Year Quarter Location CarClass Revenue  NumCars  AvgRev
2015 Q1 Airport Economy 342140 3267 $104.73
2015 Q2 Airport Economy 422192 4068 $103.78
2015 Q3 Airport Economy 580576 3214 $180.64
2015 Q4 Airport Economy 533744 3576 $149.26
2016 Q1 Airport Economy 486252 3440 $141.35
2016 Q2 Airport Economy 486056 3424 $141.96
2016 Q3 Airport Economy 503212 3287 $153.09
2016 Q4 Airport Economy 555768 3848 $144.43
2017 Q1 Airport Economy 589668 3524 $167.33
2017 Q2 Airport Economy 427320 3947 $108.26
2015 Q1 Airport Premium 349852 3205 $109.16
2015 Q2 Airport Premium 370128 3487 $106.15
2015 Q3 Airport Premium 752272 3581 $210.07
2015 Q4 Airport Premium 496840 3192 $155.65
2016 Q1 Airport Premium 701460 3787 $185.23
2016 Q2 Airport Premium 626232 3392 $184.62
2016 Q3 Airport Premium 665548 3474 $191.58
2016 Q4 Airport Premium 687844 3327 $206.75
2017 Q1 Airport Premium 912900 3602 $253.44
2017 Q2 Airport Premium 561124 3371 $166.46
             
             
Average Quarterly Revenue per Economy Car (Airport) $139.48  
Average Quarterly Revenue per Premium Car (Airport) $176.91  

I’m stuck when creating a 2 simple bar charts from the above spreadsheet. Trying to create a bar chart for the following.

1. A bar chart that clearly shows the average revenue per ECONOMY car versus the quarter for 2015. 

2. A bar chart that clearly shows the average revenue per PREMIUM car versus the quarter for 2015. 

By: Dennis

Leave a Reply

Your email address will not be published. Required fields are marked *