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

Determination of water hardness by edta titration calculations - How to get the percent yield - Narrative writing Exercise - How do protozoa reproduce - Goal setting theory of motivation - Tiffany and co financial analysis - Fire protection hydraulics and water supply - The developing person through the lifespan 9th edition chapter 1 - A passageway connecting neighboring osteocytes in an osteon is a - Mali einsteini solowa misja ani - Becton labs inc produces various chemical compound for industrial use - Dalhousie university economics - Explain two principles of competent effective interpersonal communications - Annotated Bibliography - Tata durashine dealers in himachal pradesh - Iron man suit special effects - 316-a4 - Introduction to sociology seagull 11th edition pdf - Dig deep beyond lean in by bell hooks - Write a select statement that returns these columns from the invoices table - What is an entity supertype - How to run independent sample t test in spss - Trevor noah mother is she still alive - You have $10000 to invest in a stock portfolio - Tlmt601 - trade association : Journal Article 3 - Supply chain challenges at leapfrog case study answers - Isbn 10 1 305 38983 2 - Yushan bicycles australia - Companies with wide span of control - Assigning oxidation numbers worksheet part b answer key - Irony as a principle of structure analysis - Transitional Care Application: Roles and Organizational Structure - Amp flexible super unique superannuation identifier - Chaplet of the precious blood of jesus christ - Indian plumbing skills council - Market potential inde - How many strings of eight uppercase english letters are there - Week 8 discussion NS - One sentence summary of the great gatsby - Transas navi planner 4000 manual - Making connections between texts - Set notation venn diagrams - Shoo fly don't bother me - Prizm and esri's tapestry are two of the most widely used tools for _______ segmentation. - Research question - Bill nye atoms worksheet - Hp dynamic smart array b140i controller driver - Volume of a box equation - Netflix porter's five forces analysis 2017 - Understanding the steps of polymerase chain reaction lewinsky clinton scandal - Alternative solution proposal - Ford motor company case study analysis - Fanatec wheel property page download - Bimanual palpation of kidney - ASSIGNMENT - I before e except after c and sometimes y - Billy bragg do unto others chords - Excel Budget Assignment - Economics 1 - Biovail corporation case study answers - Connect chapter 5 homework financial accounting - Access chapter 6 grader project - Gcu effective communication - Discussion - Amortization calculator php code - HW - This week we are working on faculty development models for distance learning. - Prepare a presentation of the research paper submitted in week 6. - Billy elliot and mrs wilkinson scene - 4/8 lawson street moonee ponds - CSR And Value Chain Research Report - Dr deb travel doctor - The war prayer theme - 8ppol - Passive and active resistance to slavery - Paper - William shakespeare sonnet 116 analysis - St george's student union - He nurses are responsible for her continuous care and doctors visit daily to review her condition and treatment. - Leadership styles in nursing essay - The statement system.out.printf("%10s", 123456) outputs ________. (note: * represents a space) - Ring out wild bells summary - Merlot aero crew portal - Conservation of energy answer key - Professor layton and the miracle mask battle of wits - Vortex spa not heating up - Pure blonde beer dan murphy's - Neo pi-r hand scoring sheet - Complex pdu packet tracer - Nursing theory org theories and models - EP WK5 - Yung gravy okc farmers market - Basic food hygiene quiz - Cloud Computing Week 6 Assignment - How to calculate cp in excel - What are environmentally sustainable work practices - Chemistry help! - How is john proctor a hypocrite - A budget deficit would result when a person's or family's