Final Project – Part 3: Creating Visualizations

In this third part of the Final Project, you will transform your calculations and summary tables into clear, professional, and visually effective charts. These visualizations will form the core of your Sales Dashboard and will help communicate trends, comparisons, and key performance indicators at a glance.

You will create three essential chart types used in business reporting:

• Column Chart – for comparing categories or regions
• Line Chart – for showing monthly trends
• Pie Chart – for showing category distribution

Each chart will be built using the summary tables created in Part 2 – Calculations Layer.

---

1. Prepare Your Data for Charting

Before creating charts, make sure your summary tables are clean, complete, and properly formatted.

Review the following lessons if needed:

• 4.1 Creating Excel Tables
• 4.4 Conditional Formatting
• 6.5 Best Practices for Clean Spreadsheets

Ensure that:

• Each summary table has clear headers
• No blank rows or columns are present
• Numbers are formatted consistently
• Months are sorted correctly (1–12)

---

2. Create a Column Chart (Sales by Region)

Column charts are ideal for comparing values across categories. In this project, you will create a column chart showing Total Sales by Region.

Steps:

1. Select your Region Summary table (Region + Total Sales).
2. Go to Insert → Column or Bar Chart.
3. Choose Clustered Column.
4. Move the chart to a new sheet named Charts.
5. Apply a clean, professional style.

Formatting Tips:

• Remove unnecessary gridlines
• Use a neutral color palette
• Increase font size for readability
• Add a clear title: Sales by Region

Review chart basics in Lesson 5.1 – Basic Charts.

---

3. Create a Line Chart (Monthly Sales Trend)

Line charts are perfect for showing trends over time. You will create a line chart showing Monthly Total Sales.

Steps:

1. Select your Monthly Summary table (Month + Total Sales).
2. Go to Insert → Line or Area Chart.
3. Select Line with Markers.
4. Move the chart to the Charts sheet.
5. Format the chart for clarity.

Formatting Tips:

• Use a single, clean line color
• Highlight the highest and lowest points
• Add a title: Monthly Sales Trend
• Ensure months are sorted correctly

For quick formatting, try the Quick Analysis Tool (Lesson 5.2).

---

4. Create a Pie Chart (Sales by Category)

Pie charts are useful for showing proportions. You will create a pie chart showing Total Sales by Category.

Steps:

1. Select your Category Summary table.
2. Go to Insert → Pie Chart.
3. Select 2-D Pie.
4. Move the chart to the Charts sheet.
5. Apply a clean, minimal style.

Formatting Tips:

• Use no more than 4–5 colors
• Sort slices from largest to smallest
• Add data labels with percentages
• Title: Sales by Category

---

5. Apply Professional Chart Formatting

To make your charts look polished and consistent:

• Use the same font across all charts
• Use consistent colors for similar categories
• Remove chart borders
• Use light gridlines or none at all
• Align titles and labels clearly

Review formatting best practices in Lesson 6.5 – Best Practices for Clean Spreadsheets.

---

6. Organize All Charts in a Dedicated Sheet

Create a sheet named Charts and place all visualizations there. This keeps your workbook clean and prepares the charts for the dashboard layout.

Use Freeze Panes if needed to keep headers visible.

---

7. Practical Exercise

1. Create a sheet named FP_Part3_Charts.
2. Create a Column Chart for Sales by Region.
3. Create a Line Chart for Monthly Sales Trend.
4. Create a Pie Chart for Sales by Category.
5. Apply consistent formatting across all charts.
6. Organize all charts neatly in the Charts sheet.

---

Next Part

Continue with the next phase of the project: Final Project – Part 4: Building the Dashboard Layout