Question
Please help! SOS This worksheet contains a table of yields for corn, sorghum, and wheat in New Mexico for the years 2009 through 2018. There
Please help! SOS
This worksheet contains a table of yields for corn, sorghum, and wheat in New Mexico for the years 2009 through 2018. There is a drop-down list in cell J2 that allows the user to select one of these three crops. The chart should display the yield data for whichever crop has been selected. However, the charts data comes from cells M4:M13. Thus, these cells should contain the crop yields for the selected crop associated with the years in cells L4:L13. For example, if corn has been selected, cell M4 should equal 190. If sorghum has been selected, cell M4 should equal 46. Enter formulas into M4:M13 to return the correct data based on the selected crop.
File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Queries & Connections + Le Recent Sources [ Existing Connections A1 14 From Text/CSV L From Web From Table/Range M Clear Reapply Advanced 1 % Group Ungroup Properties Get Data Refresh All Stocks Filter Geography I Sort EX Text to Columns EO Edit Links What If Forecast Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline M19 B D E F G H | J L M N O Q R S T U V W Select crop for charting: Corn New Mexico Corn Yield, bu/ac 1.2 1 Year 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Corn 190 180 180 170 190 195 180 150 134 187 Sorghum 46 66 64 42 34 42 47 41 35 38 Wheat 20 28 21 27 44 28 25 22 30 15 0.8 Crop Data for Chart 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0.6 0.4 0.2 0 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 -Yield (bu/ac) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Queries & Connections + Le Recent Sources [ Existing Connections A1 14 From Text/CSV L From Web From Table/Range M Clear Reapply Advanced 1 % Group Ungroup Properties Get Data Refresh All Stocks Filter Geography I Sort EX Text to Columns EO Edit Links What If Forecast Analysis Sheet Subtotal Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline M19 B D E F G H | J L M N O Q R S T U V W Select crop for charting: Corn New Mexico Corn Yield, bu/ac 1.2 1 Year 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 Corn 190 180 180 170 190 195 180 150 134 187 Sorghum 46 66 64 42 34 42 47 41 35 38 Wheat 20 28 21 27 44 28 25 22 30 15 0.8 Crop Data for Chart 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 0.6 0.4 0.2 0 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 -Yield (bu/ac) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started