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
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Question
Provide a suitable chart for the 4 spread
![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 +
>
|](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F50ee8c08-bdb6-49cd-9014-91cd3b523354%2F047305d6-3e8c-4a5f-8174-ffd48e28380b%2F4qrhex8_processed.jpeg&w=3840&q=75)
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
![](/static/compass_v2/shared-icons/check-mark.png)
Step 1
Let's do the chart one by one from the beginning
Step by step
Solved in 5 steps with 8 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education