Program Statement

Create various Excel charts to visualize and interpret different datasets.

---

Dataset 1: Student Subject Marks

Task 1 – Clustered Column Chart (Subject-wise Comparison)

1. Select the entire table
2. Insert → Column Chart → Clustered Column
3. Chart Title: "Subject-wise Student Performance"
4. Interpretation: The subject with the highest column values across all students shows the highest average performance.

Task 2 – Bar Chart (Total Marks per Student)

• Add a Total column: =SUM(B2:E2)
• Select Student + Total columns → Insert → Bar Chart
• Interpretation: The longest bar indicates the top-performing student.

---

Dataset 2: Monthly Sales Data

Task 3 – Line Chart (Sales Trend)

• Select Month + Sales columns → Insert → Line Chart
• Interpretation: The month with the steepest upward slope shows maximum growth.

Task 4 – Area Chart (Cumulative Sales)

• Select Month + Cumulative Sales → Insert → Area Chart
• Why Area Chart? It visually fills the area under the line, making cumulative growth more obvious than a Line Chart.

---

Dataset 3: Company Market Share

Task 5 – Pie Chart (Market Share)

• Select Company + Market Share → Insert → Pie Chart → 2-D Pie
• Add data labels (percentage)
• Interpretation: The largest slice (TechCorp at 35%) dominates the market.

---

Dataset 4: Height vs Weight (Scatter Plot)

Task 6 – Scatter Plot (Correlation Analysis)

• Select Height + Weight → Insert → Scatter → Scatter with only Markers
• Interpretation: As height increases, weight also increases — this indicates a positive correlation between height and weight.