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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!