Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Apply a ½ point black, text 1 outline to the chart area

16/11/2020 Client: arwaabdullah Deadline: 3 days

Excel 2013 Chapter 3 Creating and Editing Charts Last Updated: 2/4/15 Page 1

USING MICROSOFT EXCEL 2013 Independent Project 3-4

Independent Project 3-4 For this project, you create a column chart to illustrate April–September revenue for Classic Gardens and Landscapes. You also create a pie chart sheet to graph the proportion that each category contributes to total revenue.

Skills Covered in This Project

 Create a chart object.

 Size and position a chart object.

 Edit and format chart elements.

 Edit the source data for a chart

 Use the SUM function in a worksheet.

 Create a pie chart sheet.

 Use texture as fill

 Add and format data labels.

1. Open the ClassicGardensRevenue-03 start file.

NOTE: If the workbook opens in Protected View, click the Enable Editing button in the

Message Bar at the top of the workbook so you can modify it.

2. The file will be renamed automatically to include your name. Change the project file name if directed to do so

by your instructor, and save it.

3. Create a Clustered Column chart object for cells A4:G9.

4. Move the chart object so that its top left corner is at cell A12. Size the bottom of the chart to

reach cell H30.

5. Edit the chart title to display CGL Major Sales Revenue on one line and Second and Third Quarters on the

second line. (Press the Enter key between the lines.)

6. Set the first line of the chart title to a font size of 20 pt. Set the second title line to a size of 14 pt.

7. Apply chart Style 14 to the chart.

8. Apply a ½ point Black, Text 1 outline to the chart.

9. Remove the Design Consulting data

series from the chart using the resizing

pointer.

10. Enter SUM functions for the total column

H5:H9 and total row B10:H10.

11. Create a 3-D Pie chart sheet named

Revenue Breakdown for cells A4:A9 and H4:H9. (Hint: use the Move Chart button.)

IMPORTANT: To ensure accurate grading,

you must complete step 11 correctly in

order to receive points for completing the

next steps. Check your work carefully.

12. Edit the chart title to display Revenue by Category. Set the font size to 32.

13. Apply the Oak texture fill to the Tree and Shrubbery slice. If you cannot find the Oak texture in the Texture

gallery use a texture of your choice.

Step 1

Download start file

Move Chart dialog

Excel 2013 Chapter 3 Creating and Editing Charts Last Updated: 2/4/15 Page 2

USING MICROSOFT EXCEL 2013 Independent Project 3-4

14. Add data labels to the chart.

a. Select Center for the label position. Choose the Accounting format and set 0 decimal places (Figure 3-69).

b. While the data labels are selected, set the font size to 14 pt. and make them bold [Home tab, Font group].

15. Save and close the workbook (Figure 3-70).

16. Upload and save your project file.

17. Submit project for grading.

3-70 Excel 3-4 completed worksheet and chart sheet

Step 2

Upload & Save

Step 3

Grade my Project

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Buy Coursework Help
Quality Homework Helper
Peter O.
A+GRADE HELPER
Writer Writer Name Offer Chat
Buy Coursework Help

ONLINE

Buy Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Quality Homework Helper

ONLINE

Quality Homework Helper

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Peter O.

ONLINE

Peter O.

Hello, I can assist you in writing attractive and compelling content on ganja and its movement globally. I will provide with valuable, informative content that you will appreciate. The content will surely hit your target audience. I will provide you with the work that will be according to the needs of the targeted audience and Google’s requirement.

$55 Chat With Writer
A+GRADE HELPER

ONLINE

A+GRADE HELPER

Greetings! I’m very much interested to work on this project. I have read the details properly. I am a Professional Writer with over 5 years of experience, therefore, I can easily do this job. I will also provide you with TURNITIN PLAGIARISM REPORT. You can message me to discuss the detail. Why me? My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks!

$55 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Go north east zones - Discussion - Spelling connections 7 answers - U substitution practice worksheet - Sociology - Teaching emotion recognition autism worksheets - Hunches that communication theory are built about should be - Academic integrity essay - Why are the chlorophylls less mobile - An organization pursuing a loyal soldier hr strategy - How many wives does okonkwo have - CIS 505 Week 8 Assignment - Review - Century national bank case study answers - Discussion 4 - Motor velocity constant kv - Kite runner quiz chapters 1 9 - Cisco meraki mdm datasheet - Bruce lincoln holy terrors pdf - Labquest 2 for sale - Many studies show social media networks have a very strong impact on external workplace communication. What about their impacts on internal workplace communication? Discuss and give your opinion in management perspective. - Kmc property tax calculation - Individual Ted Talk Presentation (up to 5 minutes) make a ppt with pictures and less words, also need a speech draft - Biology Discussion Questions - Which ions remain in solution after pbi2 precipitation is complete - Boq rates in sri lanka - Wanttoknowit com who invented the candy cane - Mres developmental neuroscience and psychopathology - Half a page - Intro to Social Work - Do My Homework - AG - L3 - Draw erd in visio - 32x16 and 32x32 rgb led matrix - Big Data Management Question Paper - Sanyco grand industries sdn bhd - Written warning template for absenteeism - Paper writing - Excel 2016 module 8 review assignment - Best Love Vashiakran Specialist Baba Ji+91-9924492424 - Vitamins calories per gram - Project cost and time managment - Dr lash trials in tainted space - Ranked vulnerability risk worksheet - Glisten medication for diabetes - Latrobe referencing apa 7 - Four building blocks of financial statement analysis - Assignment: Diverse Populations in the Military, 6212 wk-2 - Finance Paper - Case analysis 3 - Agriculture persuasive speech topics - ____ control is a method of gathering information about performance deficiencies as they occur. - Dunkin donuts human resource management - 100% Tested safe Abortion pills +27835179056 ÆÆÆ((((&&&)) ABORTION CLINIC Wartburg York Noodsberg Harburg Harding Ramsgate Hibberdene - Bcc small lot code - Takeuchi tb290 lifting chart - Wolfson house kcl address - Lloyds pharmacy pulse oximeter - I love u daddy shrek - Arms and cups checklist - Choir director job description - Different types of artifacts in radiography - Impediments to critical thinking - Standardized instruments in social work practice - Legal implications of moving business abroad - Gap inc gallatin tn - Eaton fault code 25 - Biology analyzing data answers - Are police officers public servants - Keith jesperson psychological profile - Big Data Analytics in organisation - QNT561 Week 6 Final Exam SCORE 87 PERCENT - I need help in creating a thorough powerpoint w/ presenter's notes - Online course registration system class diagram - Aldehyde or ketone higher boiling point - Ap chemistry kinetics practice problems - My courses cty online - Accountig paper - Distribution patterns in international marketing - Econ hw - Colorimetry method a level - Suppose a bakery reports this information - Criminal justice trends paper - Formulating your brief data visualization - Where should cleaning chemicals be stored in a restaurant - Context of rear window - Project 1: Explore Networking in the Cloud ( please submit Steps 4, 5, 6, and 7 separately) - What should be a firm's primary long term financial objective - Martingale asset management case study solution - Pb no3 2 2ki pbi2 2kno3 - Black dog blues lyrics russell morris - Initiating the Project - Problem Set 7 - Orange county school of the arts - Maps and globes ppt - Chain measurement in metres - Vicroads change of name - Assassin's creed odyssey photios pre retirement - Ancient egyptian makeup tools - Business Valuation Discussion Post - Project - Informatica data analyst resume