Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Issue formatting a line chart by certain specifications within a table with seven columns of information in excel. Heres the question copy-pasted from my instructor
Issue formatting a line chart by certain specifications within a table with seven columns of information in excel.
Heres the question copy-pasted from my instructor with the table:
- Insert a line chart to show the total sale amount for each order by order date.
- Create the line chart using just the data from the Order Date and Total Sale columns. Be sure to include the header row when selecting the data for the chart.
- There was an ordering glitch on August 31 that caused a spike in sales. Apply a filter to the chart to hide orders from that date. Notice the effect on the chart.
- If necessary, move the chart so it does not cover the table data.
- Add a slicer to the table so you can filter by shoe name. Use the slicer to display data for the Sperry shoe only. Notice the effect on the chart.
A step by step description on how to do this with some pictures would be much appreciated. Thank you!
Order - Regio Sales Per Shc # of P Price Per Total Sale 10/12/2019 California Howard Avone 281 $ 46.92 $ 13,184.52 8/14/2019 Oregon Gill Avone 200 $ 66.99 $ 13,398.00 4/25/2019 California Jarez Avone 229 $ 66.99 $ 15,340.71 4/8/2019 California Jones Avone 236 $ 56.99 $ 13,449.64 11/7/2019 Washingtc Thompson Gracie 280 $ 59.99 $ 16,797.20 9/8/2019 Oregon Jardine Darla 8888 $ 46.92 $ 417,024.96 6/15/2019 California Jarez Darla 113 $ 13.99 $ 1,580.87 5/12/2019 Oregon Green Darla 93 $ 46.92 $ 4,363.56 3/5/2019 California Jones Darla 81 $ 33.99 $ 2,753.19 3/5/2019 California Jones Darla 270 $ 33.99 $ 9,177.30 1/5/2019 Oregon Morgan Darla 156 $ 10.49 $ 1,636.44 1/5/2019 Oregon Morgan Darla 176 $ 10.49 $ 1,846.24 12/2/2019 Oregon Green Flip 215 $ 10.50 $ 2.257.50 2/17/2019 Oregon Smith Flip 77 $ 10.50 $ 808.50 8/31/2019 Washingte Vosburger Gracie 263 $ 45.34 $ 11,924.42 12/11/2019 Oregon Morgan Gracie 178 $ 46.92 $ 8,351.76 8/31/2019 Washingte Vosburger Gracie 110 $ 45.34 $ 4,987.40 10/29/2019 Oregon Gill Gracie 223 $ 27.00 $ 6,021.00 10/4/2019 Oregon Andrews Gracie 75 $ 59.99 $ 4,499.25 8122/2019 Washingtc Vosburger Sperry 77 $ 66.99 $ 5,158.23 3131/2013 Washingte Thompson Sperry 127 $ 66.99 $ 8,507.73 7/28/2019 Oregon Jardine Gracie 217 $ 46.92 $ 10.181.64 6/24/2019 California Jones Gracie 148 $ 59.99 $ 8,878.52 5/29/2019 Oregon Smith Gracie 91 $ 36.29 $ 3,302.39 12/28/2019 California Howard Sperry 117 $ 59.99 $ 7,018.83 9/17/2019 California Jones Sperry 106 $ 46.92 $ 4,973.52 3/14/2019 Washingte Vosburger Avone 95 $ 59.99 $ 5,699.05 7/19/2019 Oregon Smith Sperry 85 $ 66.99 $ 5,694.15 7/11/2019 Oregon Green Sperry 109 $ 66.99 $ 7,301.91 7/2/2019 Oregon Gill Sperry 96 $ 66.99 $ 6,431.04 6/7/2019 Oregon Andrews Sperry 117 $ 46.92 $ 5,489.64 5/4/2019 Oregon Jardine Sperry 159 $ 46.92 $ 7,460.28 2/8/2019 Washingte Vosburger Flip 100 $ 8.35 $ 835.00 3122/2019 Oregon Morgan Sperry 92 $ 6.99 $ 643.08 1/14/2019 California Jarez Sperry 229 $ 66.99 $ 15,340.71 Total 403.11 $ 44.61 $ 652.318.18 Order - Regio Sales Per Shc # of P Price Per Total Sale 10/12/2019 California Howard Avone 281 $ 46.92 $ 13,184.52 8/14/2019 Oregon Gill Avone 200 $ 66.99 $ 13,398.00 4/25/2019 California Jarez Avone 229 $ 66.99 $ 15,340.71 4/8/2019 California Jones Avone 236 $ 56.99 $ 13,449.64 11/7/2019 Washingtc Thompson Gracie 280 $ 59.99 $ 16,797.20 9/8/2019 Oregon Jardine Darla 8888 $ 46.92 $ 417,024.96 6/15/2019 California Jarez Darla 113 $ 13.99 $ 1,580.87 5/12/2019 Oregon Green Darla 93 $ 46.92 $ 4,363.56 3/5/2019 California Jones Darla 81 $ 33.99 $ 2,753.19 3/5/2019 California Jones Darla 270 $ 33.99 $ 9,177.30 1/5/2019 Oregon Morgan Darla 156 $ 10.49 $ 1,636.44 1/5/2019 Oregon Morgan Darla 176 $ 10.49 $ 1,846.24 12/2/2019 Oregon Green Flip 215 $ 10.50 $ 2.257.50 2/17/2019 Oregon Smith Flip 77 $ 10.50 $ 808.50 8/31/2019 Washingte Vosburger Gracie 263 $ 45.34 $ 11,924.42 12/11/2019 Oregon Morgan Gracie 178 $ 46.92 $ 8,351.76 8/31/2019 Washingte Vosburger Gracie 110 $ 45.34 $ 4,987.40 10/29/2019 Oregon Gill Gracie 223 $ 27.00 $ 6,021.00 10/4/2019 Oregon Andrews Gracie 75 $ 59.99 $ 4,499.25 8122/2019 Washingtc Vosburger Sperry 77 $ 66.99 $ 5,158.23 3131/2013 Washingte Thompson Sperry 127 $ 66.99 $ 8,507.73 7/28/2019 Oregon Jardine Gracie 217 $ 46.92 $ 10.181.64 6/24/2019 California Jones Gracie 148 $ 59.99 $ 8,878.52 5/29/2019 Oregon Smith Gracie 91 $ 36.29 $ 3,302.39 12/28/2019 California Howard Sperry 117 $ 59.99 $ 7,018.83 9/17/2019 California Jones Sperry 106 $ 46.92 $ 4,973.52 3/14/2019 Washingte Vosburger Avone 95 $ 59.99 $ 5,699.05 7/19/2019 Oregon Smith Sperry 85 $ 66.99 $ 5,694.15 7/11/2019 Oregon Green Sperry 109 $ 66.99 $ 7,301.91 7/2/2019 Oregon Gill Sperry 96 $ 66.99 $ 6,431.04 6/7/2019 Oregon Andrews Sperry 117 $ 46.92 $ 5,489.64 5/4/2019 Oregon Jardine Sperry 159 $ 46.92 $ 7,460.28 2/8/2019 Washingte Vosburger Flip 100 $ 8.35 $ 835.00 3122/2019 Oregon Morgan Sperry 92 $ 6.99 $ 643.08 1/14/2019 California Jarez Sperry 229 $ 66.99 $ 15,340.71 Total 403.11 $ 44.61 $ 652.318.18Step 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