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

Summary_22 - Grace to you sermon - Hooters bfoq - Rachael ray sauteed red cabbage - Kansas civil service jobs - Capsim final company performance summary - The coca cola company motivate - Endothermic and exothermic reactions lab answers - Why does isabella fall in love with heathcliff - The cask of amontillado article - Ignition automation university - The hollow men setting - Pico question examples congestive heart failure - Cost index for airlines - Musculoskeletal system shadow health assessment - A steel cable with cross sectional area - Conservation of energy at the skate park answer key - Multiple choice questions on justice - WK4DISCUSSION091720 - Chapter 11 managing weight and eating behaviors vocabulary practice answers - What rule does ralph set for the tribe - Kobo touch case uk - Sox compliance accounts payable - Qls default interest rate - Which promotional activity will sell the most products - Escoge la opción que mejor resume el cortometraje - Southwest airlines tangible and intangible resources - Hairline crack in denture plate - Penn foster writing assignment - Big bertha stories by bobbie ann mason - Pelton wheel turbine lab report - Pearson brothers recently reported an ebitda of $7.5 million - Conservation projects in pompeii and herculaneum - Standard business reporting sbr - Ford ll5 salary range - English - Lower back pain soap note example - Organization leadership Research paper - How to solve integer word problems - 15/1 assembly drive varsity lakes - Titration for acetic acid in vinegar lab - Axial flow fan diagram - Types of organizational interventions - Community teaching work plan proposal - Writing business letters useful phrases - Tone colour definition music - Explain how Enterprise Risk Management (ERM) empowers organizations to both avoid loss and capitalize on opportunity - Miami dade college medical campus nursing - What is role performance in sociology - What are the rules of beer pong - Castagna genesis syrah 2009 - Melbourne tv guide free to air tonight - Business services training package assessment guidelines - Using the following information prepare a bank reconciliation - Wk 4: Discussion 1: Eating disorders - Background and Methods Section - Acm computing surveys latex template - What is the value of a hanging drop preparation - Journal of accounting and public policy ranking - Design your own coat of arms - Academic journal of interdisciplinary studies - Bowlby 1951 maternal care and mental health - Ernest hemingway birth and death - William wharton green mile - Capital acquisition and repayment cycle - Hansson private label case - Musculoskeletal - Temptrak temperature monitoring system - Quintus curtius rufus the history of alexander pdf - Pt tata consultancy services indonesia - Pinto fires and personal ethics summary - Coun 646 case study 3 - Australian government protective security manual - Reflection paper - What is chlorsig eye drops - Martin scorsese and quentin tarantino - Express complex number in exponential form - How many trips originate in each state - The major industries that developed in the south prior to 1900 included all of the following except - When is year of wonders set - Original cost $45 markup 20 - Exploratory verbs examples - Cystoscopy urethral dilation and hydrodilation - Whats ethos pathos logos - Assignment 3 creating training tools 200 pts - The pleasure of my company - The 18th amendment modified answer key - Abc co and xyz co are identical firms - Sam edelman fritz genuine cow fur flat - Why shouldn t guns be allowed on college campuses - Asg2 - Australian tax tables weekly - Bus to new victoria hospital glasgow - Power triangle of ac circuit - Difference between ralph tyler and hilda taba - Josie king story video - Lockwood digital lock instructions - Nca credo for ethical communication - Transportation draft paper - Https www eprocurement gov cy