Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Harness The Power Of Big Data The IBM Big Data Platform
Authors: Paul Zikopoulos, David Corrigan James Giles Thomas Deutsch Krishnan Parasuraman Dirk DeRoos Paul Zikopoulos
1st Edition
0071808183, 9780071808187
