Assignment 4A – Dual Axis Charts and More… 1 answer below »
Assignment 4A – Dual Axis Charts and More… 1 answer below »
Save GBI Dataset 4B as a new workbook with your name included in the title. On the “Reliance” tab, create a dual-axis chart comparing the trends in sales. There are many choices of comparisons you can build with the data provided. Note – You may have to “Switch Row/Column” to get the year to be your bottom axis for trending analysis. Also, you may want to create one type of chart first and then “Change Chart Type” to “Combo” to create your dual axis chart. You will be selecting the type of chart for each data series and the axis for it in the help box. Answer the questions: “What information/insights should your dual axis chart present? What conclusions, if any, can you draw from the chart?” On the “Seasonality” tab, create a visual presentation (chart or graph) that will be helpful in analysis of whether there is monthly seasonality in the sales of the company. Answer the following questions regarding the information: Is there evidence of monthly seasonality in sales of GBI Worldwide? Why did you select the chart and configuration you created versus another chart, graph or depiction for your analysis? Reminders: Be sure to include chart title, labels and data identification. Be careful of when you do/don’t include the totals, as they often
