BUSINESSEDUCATIONNY
  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks

Domain 5 Lesson 2
Format Charts

1 Chart Layouts (TEMPORARY)

Change the chart type of the Swimming Attendance chart to a 3-D Clustered Column layout. Then, apply the Layout 5 layout to the chart.
  1. Click the Swimming Attendance chart
  2. Click the Design tab under Chart Tools
  3. In the Type group, click Change Chart Type
  4. Make sure that Column is selected on the left-hand side
  5. Click the 3-D Clustered Column chart type from the list across the top of the All Charts tab
  6. Click the OK button
  7. In the Chart Layouts group, click the Quick Layout drop-down arrow
  8. Click Layout 5

2 Chart Styles

Apply the Style 9 style to the Swimming Attendance chart on Sheet1. Then, apply the Monochromatic Palette 3 color combination to the chart.
  1. Click the Swimming Attendance chart on the Sheet1 worksheet
  2. Click the Design tab under Chart Tools
  3. In the Chart Styles group, click the Chart Styles drop-down arrow
  4. Click Style 9
  5. In the Chart Styles group, click the Change Colors drop-down button
  6. Click the Monochromatic Palette 3 color group option

3 Add Alternative Text

Add the text, Percentage of totals for each swim class, as alternative text to the Chart Area of the pie chart.
  1. Select the entire pie chart
  2. In the Chart Format tab, Current Selection group, ensure that the drop-down has Chart Area selected.
  3. In the Chart Format tab, Accessibility group, click Alt Text
  4. Click in the Alt Text field
  5. Type: Percentage of totals for each swim class

Mr. Kazanjian's Business Class
Hempstead High School
Room A112
​[email protected]

  • Home
  • CPU Applications
  • Marketing
    • Marketing Introduction
    • Module 1: Marketing Today & Tomorrow
    • Module 2 Socially Responsive Marketing
    • Module 3: Marketing Begins With Economics
    • Module 4: The Basics Of Marketing
    • Module 5: Marketing Information & Research
    • Module 6: Marketing Starts With Customers
    • Module 7: Competition Is Everywhere
    • Module 8: E-Commerce And Virtual Marketing
    • Module 9: Developing A Marketing Strategy & Marketing Plan
  • Desktop Publishing
  • CFM 25-26
  • CPU APP COLLEGE
    • Part 1 Excel 200
    • Part 2 Excel 201 Advanced
    • Part 3: Microsoft Access 500
    • Part 4: Mr. Kazanjian's Tips & Tricks