A 1 2 3 4 5 6 7 8 9 10 fx 1 2 3 4 5 6 fx Months 7 8 9 10 11 12 Grand Total A fx A 1 2 3 4 5 6 7 8 Months 7 8 9 10 11 tant A A 1 Consultant 2 3 4 5 6 7 8 Enter text or formula here A B Company 1 Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total A Months 167.9 691.9 859.8 C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 7 9 8 10 11 12 Links Disabled - Links to external workbooks are not supported and have been disabled. B 87.2 167.9 458.7 Enter text or formula here Grand Total Company 1 87.2 458.7 545.9 B 364.1 598.8 652.6 Hour totals by Consultant 1615.5 Enter text or formula here total hours by consultant by mo 24 172.1 178 184 168 с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 178.7 904.8 246.2 Links Disabled - Links to external workbooks are not supported and have been disabled. C 364.1 598.8 652.6 D Anderson, Brant Johnson, Andrea Smith, Kade 36 167.9 171.7 184.4 167.9 176.2 904.1 89.4 F 197.1 171.6 181.2 639.3 1.7 1.7 B C D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 270.4 357.4 4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Company 6 Links Disabled - Links to external workbooks are not supported and have been disabled. Total Sales By Month By Custome E F Total Hours By Category 24.3 169.4 176.3 179 119.1 155.8 823.9 G 4.6 7.5 0 0 12.1 F Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 3 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G Tota F V
A 1 2 3 4 5 6 7 8 9 10 fx 1 2 3 4 5 6 fx Months 7 8 9 10 11 12 Grand Total A fx A 1 2 3 4 5 6 7 8 Months 7 8 9 10 11 tant A A 1 Consultant 2 3 4 5 6 7 8 Enter text or formula here A B Company 1 Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total A Months 167.9 691.9 859.8 C D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 7 9 8 10 11 12 Links Disabled - Links to external workbooks are not supported and have been disabled. B 87.2 167.9 458.7 Enter text or formula here Grand Total Company 1 87.2 458.7 545.9 B 364.1 598.8 652.6 Hour totals by Consultant 1615.5 Enter text or formula here total hours by consultant by mo 24 172.1 178 184 168 с D E Company 2 Company 3 Company 4 Company 5 84.3 161.9 178.7 904.8 246.2 Links Disabled - Links to external workbooks are not supported and have been disabled. C 364.1 598.8 652.6 D Anderson, Brant Johnson, Andrea Smith, Kade 36 167.9 171.7 184.4 167.9 176.2 904.1 89.4 F 197.1 171.6 181.2 639.3 1.7 1.7 B C D E Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours 533.8 320.7 45.7 270.4 357.4 4 595 289.6 19.5 480 295.9 48 1879.2 1263.6 117.2 Company 6 Links Disabled - Links to external workbooks are not supported and have been disabled. Total Sales By Month By Custome E F Total Hours By Category 24.3 169.4 176.3 179 119.1 155.8 823.9 G 4.6 7.5 0 0 12.1 F Stewart, Travis Grand Total 84.3 598.8 526 744.5 626.6 691.9 3272.1 3 3 1.7 G Company 6 Grand Total 84.3 526 598.8 744.5 626.6 691.9 3272.1 H H G Tota F V
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.12CP
Related questions
Question
Provide a suitable chart for the 4 spread
Transcribed Image Text:Instructions
For this assignment, there are four different types of charts that you
will need to create.
also have needed to have determined which chart type fits the best for
each question (there could be more than one answer, but you only
need to choose one for each question). You will also need to create the
chart based upon the data in the Excel spreadsheet. There are four tabs
in the worksheet below.
NNNNNNNN
18
19
20
21
23
24
25
Design
Development
26 Documentation
www
1
Hourly Category
2
Attend Training
3
Conduct Training
4
Configuration
5
Content Development
6
CRM Configuration
7 CRM Data Migration
8 CRM Design
9
10
11
12 CRM Integration Implementation
13
CRM Project Management
14 CRM Report Customization
15
CRM Scoping
16
CRM Support
17
CRM Testing
CRM Upgrade Installation
CRM Upgrade Scoping
CRM Workflow Customization
Data Migration
1. For the "Hour Totals By Consultant" tab, I need for you to
pick a chart type that will allow me to see the distribution
of the types of time entries entered by consultant. There
are four types of possible hour types, "PTO", "Travel
Hours", "Non-Billable Hours", and "Billable Hours". The title
of the chart should be "Total Hours by Consultant by Hour
Type". Please create this chart and put it on that tab. You
can format it however you like. However, make sure that
the format you choose accomplishes the goal of the chart.
2. For the "total hours by consultant by mo" tab, I need for
you to pick a chart type that shows the trend by
month. The chart should show the months in the correct
order. Also, I need to see that trend by consultant. Create
this chart on the same tab. You can format it however you
like. However, make sure that the format you choose
accomplishes the goal of the chart.
3. For the "total hours by category" tab, I need for you to
pick a chart type that will allow for me to determine the
total hours by category and its percentage of the whole.
Make sure the chart is easy to read. You can choose
whatever format you like. However, make sure that the
format you choose accomplishes the goal of the chart.
4. For the "totals sales by month by cust." tab, I need for you
to create a chart that looks like this:
Total Sales by Month by Customer
31
800
700
600
500
400
Links Disabled - Links to external wo
22 Database/Company Set Up
Demonstration
300
200
100
fx
0
27 Form Customization
28 Holiday
29 Installation
30
U
A
CRM Development
CRM Form Customization
CRM Installation
fx
32
33
34
35
36
37
38 Research
39 Sales Support
40
Scoping
41 Scribe Installation
Integration Design
Office Time
Onsite Support
Preparation/Planning
LO
Project Management
PTO
42 Scribe Integration Support
43
Self Study
44 Status Meeting
45 Subject Matter Expert Consulting
46 Support
47
48
49
50
51 Upgrade Testing
52 Workflow Customization
53
Grand Total
54
Remote Service Pack Deployment
Report Customization
System Administration
Team Meeting
Testing
Upgrade Installation
7
1 Months
2 7
3 8
4 9
5 10
6 11
7 12
8 Grand Total
9
10
A
1 Months
2 7
3 8
4 9
5 10
6 11
fx
tant
A
Company 1 # Company 2 Company 3 Company 4
Enter text or formula |
Links Disabled - Links to external workbooks are not supported and have been disabled.
A
B
Sum of total Hours
149.2
38.9
20.5
182.3
44.8
10.4
57.2
25.3
42.7
0.5
6.6
164.2
12.6
34.9
349.9
19.7
12
1.3
23.8
10.6
5.6
16.3
5.9
1.6
27.3
49.5
136
20.5
1.3
687.1
14.5
8.7
76.4
117.2
2.3
56.4
8.7
4.5
64.2
0.4
0.8
113.7
15.4
1 Consultant
2 Anderson, Brant
3 Johnson, Andrea
4
5
Total Hours By Category
Smith, Kade
Stewart, Travis
6 Grand Total
7
8
fx
107.3
379.7
7.1
35.4
54.3
2.3
38.3
6
3272.1
A
1 Months
2
3
4
C
B
10
Company 1
7
9
8
10
11
12
5
6
7
8 Grand Total
fx
167.9
691.9
859.8
II
Enter text or formula here
Company 5 Company 6
D
B
11
Company 1
E
B
с
D
E
Company 2 Company 3 Company 4 Company 5
84.3
161.9
Links Disabled - Links to external workbooks are not supported and have been disabled.
87.2
458.7
Enter text or formula here
87.2
458.7
545.9
167.9
12
24
172.1
178
184
168
178.7
904.8
Hour totals by Consultant
364.1
598.8
652.6
1615.5
Enter text or formula here
total hours by consultant by mo
C
D
E
Company 2 Company 3 Company 4 Company 5
84.3
161.9
Links Disabled - Links to external workbooks are not supported and have been disabled.
C
246.2
Hour totals by Consultant
364.1
598.8
652.6
89.4
197.1
171.6
181.2
639.3
Enter text or formula here
F
B
с
D
E
Sum of Billable Hours Sum of Non-Billable Hours Sum of Travel Hours Sum of PTO Hours
533.8
320.7
45.7
4
270.4
357.4
595
289.6
19.5
480
295.9
48
1879.2
1263.6
117.2
Links Disabled - Links to external workbooks are not supported and have been disabled.
D
1.7
1.7
F
Anderson, Brant Johnson, Andrea Smith, Kade Stewart, Travis Grand Total
84.3
598.8
526
744.5
626.6
691.9
3272.1
36
167.9
171.7
184.4
167.9
176.2
904.1
Company 6
Total Sales By Month By Custome
E
F
Total Hours By Category
G
24.3
169.4
176.3
179
119.1
155.8
823.9
4.6
7.5
0
0
12.1
3
1.7
G
Company 6
Grand Total
84.3
526
598.8
744.5
626.6
691.9
3272.1
H
H
G
F
+
>
Tota +
>
|
Expert Solution
Step 1
Let's do the chart one by one from the beginning
Step by step
Solved in 5 steps with 8 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L