Скачать или смотреть Illustrated Excel 365/2021 | Module 4: SAM Project 1b

To Get this Solution Contact us on Email and WhatsApp is given in Video
WhatsApp no : +923114151799
Email address: [email protected]

Format chart title

Click the chart title.

On the Format tab, select Shape Outline → Theme Colors → Brown, Accent 6 (10th column, 1st row).

Go to Shape Effects → Shadow → Outer → Offset: Bottom Right.

Gridlines

Select the chart → Click Chart Elements (+) → uncheck Primary Major Vertical Gridlines.

Check Primary Major Horizontal Gridlines.

Horizontal axis title

Click Chart Elements (+) → Axis Titles → Primary Horizontal.

In the axis title box, type 2024 Quarters.

Select the title text → change font to Calibri Light, size 16 pt.

2. Quarterly Profit worksheet → 2-D Pie Chart

Select the pie chart → go to Chart Tools → Design → Chart Styles → Style 8 (this style shows percentages on slices).

Move legend: click the legend → go to Legend Options → Left.

Explode largest slice (Quarter 2): click Quarter 2 slice → drag slightly outward OR right-click → Format Data Point → Point Explosion: 10%.

3. New Services worksheet → Clustered Column Chart

Resize & reposition

Select the chart → drag so upper-left corner aligns with cell H3 and lower-right corner with cell N17.

Chart title

Add chart title: Quarterly Revenue.

Colors

Go to Chart Design → Change Colors → Monochromatic Palette 2.

Change data series fill

Click once on the Security plan series → right-click → Format Data Series → Fill → Dark Red, Accent 2, Lighter 40% (6th col, 4th row).

Axis values formatting

Select cells B5:F7 → apply Accounting number format → decrease decimals to 0.

This formatting applies to the chart’s vertical axis labels automatically.

4. New Chart → Quarterly Profit (Line with Markers)

Select range B20:E21 → Insert tab → Line with Markers chart.

Add chart title: Quarterly Profit.

Resize and reposition chart so upper-left corner is inside H19 and lower-right corner is inside N32.

Move the legend to the left

Chart Design Add Chart Element Legend Left.

Explode the largest slice (Quarter 2) by 10%

Click once on the Quarter 2 slice to select the whole series, then click that slice again to select just that point.

Right-click Format Data Point Series Options Point Explosion = 10%.
(Or drag the slice slightly outward, then fine-tune using Point Explosion = 10%.)

New Services worksheet (Clustered Column: Oakland revenue over four quarters)

Resize & reposition the clustered column chart

Click the chart border to select the chart area.

Drag the chart so its upper-left corner sits inside cell H3.

Drag the sizing handles so the lower-right corner ends inside cell N17.
(Tip: Zoom to 120–150% for precise corner placement.)

Add a chart title

Chart Design Add Chart Element Chart Title Above Chart.

Click the title box and type Quarterly Revenue.

Change chart colors to Monochromatic Palette 2

Chart Design Change Colors Monochromatic category Monochromatic Palette 2 (2nd one).

Recolor the “Security” data series

Click any Security column to select that series (click again if needed to ensure just that series is selected).

Right-click Format Data Series Fill & Line (paint bucket) Fill: Solid fill.

Choose Dark Red, Accent 2, Lighter 40% (Theme Colors: 6th column, 4th row).

Apply Accounting number format to the source values (updates the axis)

Select range B5:F7.

Home Number group Accounting Number Format.

Click Decrease Decimal until it shows 0 decimals.
(If the vertical axis doesn’t reflect this, right-click the vertical axis Format Axis Number Accounting, Decimal places 0, and make sure “Linked to source” is checked.)

Create a “Quarterly Profit” line chart with markers
a) Insert the chart

Select range B20:E21.

Insert Insert Line or Area Chart Line with Markers.
b) Set chart title

Click the title and type Quarterly Profit.
c) Resize & position

Drag the chart so its upper-left corner sits inside cell H19 and its lower-right corner ends inside cell N32.

#NewPerspectivesExcel2019Module1EndofModuleProject1
#NewPerspectivesExcel2019Module1EndofModuleProject2
#NewPerspectivesExcel2019Module2EndofModuleProject1
#NewPerspectivesExcel2019Module2EndofModuleProject2
#NewPerspectivesExcel2019Module3EndofModuleProject1
#NewPerspectivesExcel2019Module3EndofModuleProject2
#NewPerspectivesExcel2019Module4EndofModuleProject1
#NewPerspectivesExcel2019Module4EndofModuleProject2
#NewPerspectivesExcel2019Module5EndofModuleProject1
#NewPerspectivesExcel2019Module5EndofModuleProject2
#NewPerspectivesExcel2019Module6EndofModuleProject1
#NewPerspectivesExcel2019Module6EndofModuleProject2
#NewPerspectivesExcel2019Module7EndofModuleProject1
#NewPerspectivesExcel2019Module7EndofModuleProject2
#NewPerspectivesExcel2019Module8EndofModuleProject1
#NewPerspectivesExcel2019Module8EndofModuleProject2
#NewPerspectivesExcel2019Module9EndofModuleProject1
#NewPerspectivesExcel2019Module9EndofModuleProject2
#NewPerspectivesExcel2019Module10