Question: 7. Create the Overall Chart - this is the chart that captures the overall result: Create a slopegraph as a pivot chart that shows profitability
7. Create the "Overall Chart" - this is the chart that captures the overall result: Create a slopegraph as a pivot chart that shows profitability for 2011 and 2012 by regions. Distinguish between each of the lines with one of four colors: Color 1: Consistent poor performer O Color 2: Increasing profitability O Color 3: Decreasing profitability O Color 4: Regions that don't qualify for Colors 1-3 ( They aren't of interest). Label Color 1-3 lines directly. No label or legend is necessary for the other lines (regions). Create an attractive format/layout for this chart, complete with title, axes labels, and notes. This should be designed well enough to be placed into a printed handout for others to review. Therefore, it should speak for itself for interpretation, i.e., this is the verbose no-one-there-to-explain version. Hints: Look back at your earlier work and the book for inspiration. Yes, there will be many plotted lines in this initial chart - that is why using color and labels for demarcation is essential. Do not forget to format dollars
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
