Question: Pivot Line Chart -- create a line chart showing the percentage returns by month and by year. Step 1: Use the Pivot Table in the
| Pivot Line Chart -- create a line chart showing the percentage returns by month and by year. | ||||||||||||||||
| Step 1: Use the Pivot Table in the student work area | ||||||||||||||||
| Move the Years from Rows to Columns. | ||||||||||||||||
| Format all values to show as percentages, 0 decimals. | ||||||||||||||||
| Change column width for all Pivot Table columns to 8. | ||||||||||||||||
| Change Column Labels to "Year". | ||||||||||||||||
| Step 2:After completing the Pivot Table in the student work area, use it to create a Pivot Chart, Line Chart and position this chart in the space below. | ||||||||||||||||
| Step 3:Format Chart Area: | ||||||||||||||||
| Apply any formatting you feel is appropriate. | ||||||||||||||||
| Date | Percentage Returns |
| 2014 | 5.29% |
| Jan | 50.00% |
| Feb | 8.00% |
| Mar | 6.67% |
| Apr | 2.00% |
| May | 2.13% |
| Jun | 1.33% |
| Jul | 1.43% |
| Aug | 1.88% |
| Sep | 5.88% |
| Oct | 5.00% |
| Nov | 40.00% |
| Dec | 21.43% |
| 2015 | 7.94% |
| Jan | 20.00% |
| Feb | 10.00% |
| Mar | 6.00% |
| Apr | 9.23% |
| May | 10.00% |
| Jun | 4.38% |
| Jul | 6.50% |
| Aug | 7.14% |
| Sep | 2.22% |
| Oct | 3.43% |
| Nov | 1.00% |
| Dec | 22.22% |
| 2016 | 6.05% |
| Jan | 31.67% |
| Feb | 7.50% |
| Mar | 10.00% |
| Apr | 10.83% |
| May | 7.06% |
| Jun | 1.67% |
| Jul | 0.09% |
| Aug | 2.50% |
| Sep | 1.20% |
| Oct | 5.00% |
| Nov | 22.50% |
| Dec | 12.50% |
| 2017 | 7.62% |
| Jan | 17.78% |
| Feb | 40.00% |
| Mar | 25.00% |
| Apr | 6.43% |
| May | 5.56% |
| Jun | 2.11% |
| Jul | 4.17% |
| Aug | 5.22% |
| Sep | 1.82% |
| Oct | 2.25% |
| Nov | 17.14% |
| Dec | 10.71% |
| 2018 | 8.74% |
| Jan | 13.64% |
| Feb | 21.67% |
| Mar | 10.00% |
| Apr | 4.00% |
| May | 6.25% |
| Jun | 1.85% |
| Jul | 3.00% |
| Aug | 10.00% |
| Sep | 4.69% |
| Oct | 21.43% |
| Nov | 16.36% |
| Dec | 18.75% |
| Grand Total | 7.33% |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help