Use the following data to graph the sales revenue and net income for Walmart from 2012 to 2020 in Excel.

The data file, Walmart Trend Analysis.xlsx, is available in Connect or via the Additional Student Resources page. (Note the data is in $ millions.)

Required: Create a bar graph for sales revenue, and create a line graph for net income, formatting the x- and y-axes with year and numbers inserting appropriate chart titles.
What trends do you see for Walmart sales and Walmart net income over this time period?

Transcribed Image Text:

Year 2012 2013 2014 2015 2016 2017 2018 2019 2020 Sales Revenue $ 468,651 $ 476,294 $ 485,651 $ 482,130 $ 485,873 $ 500,343 $ 514,343 $ 523,964 $ 559,151 Net Income $ 17,756 $ 16,695 $ 17,099 $ 15,080 $ 14,293 $ 10,523 $ 6,670 $ 14,881 $ 13,510