3.2 Graphical Analysis: Bar, Line & Pie Charts in Public Reporting

3.2 Graphical Analysis: Bar, Line & Pie Charts in Public Reporting

Visual data representations transform complex public administration datasets into immediate, intuitive formats. Executive civil servants frequently rely on charts and graphs in policy briefs, agency dashboards, and reports submitted to oversight bodies like the Department of Economy, Planning, and Development (DEPDev) and Congress. However, graphical displays can also obscure critical data nuances or create misleading impressions if read superficially. The CES-WE evaluates a candidate's capacity to decode visual charts accurately, translate graphical elements into precise numerical values, and detect visual distortions.

---

Principles of Executive Data Visualization

Selecting and interpreting graphical displays depends on the nature of the underlying data structure:

---

Bar Charts: Types & Component Analysis

Bar charts display quantitative magnitudes using rectangular bars whose lengths or heights are proportional to the values they represent.

1. Simple & Clustered Bar Charts

• Simple Bar Charts: Compare single values across categories (e.g., total municipal solid waste generated across 5 LGUs).
• Clustered (Grouped) Bar Charts: Place multiple bars side-by-side for each category, allowing multi-variable comparisons (e.g., comparing male vs. female civil service employment across Salary Grades).

2. Stacked vs. 100% Component Bar Charts

• Stacked Bar Charts: Stack sub-components vertically to display the aggregate total as the full height of the bar. Reading stacked charts requires calculating segment heights by subtracting lower bounds from upper bounds ($\text{Segment Height} = \text{Top Y-value} - \text{Bottom Y-value}$).
• 100% Component Bar Charts: Standardize all bar heights to 100%. They eliminate total volume differences to focus exclusively on proportional shifts (e.g., comparing the percentage share of Personal Services vs. Capital Outlay across different agency budgets).

   STACKED BAR CHART              100% COMPONENT BAR CHART
  +------------------+           +------------------+
  | [ Capital Outlay]|           | [ Capital Outlay]|
  | [ Operating Exp ]|           | [ Operating Exp ]| 100%
  | [ Personnel Serv]|           | [ Personnel Serv]|
  +------------------+           +------------------+
     Agency A  Agency B             Agency A  Agency B

---

Line Graphs & Time-Series Trend Analysis

Line graphs connect discrete data points along a continuous scale (typically time along the horizontal X-axis). They are the primary tool for policy trend analysis.

Slope and Velocity of Change

The slope of a line segment indicates the rate of change per unit of time:

$$\text{Slope} = \frac{\Delta Y}{\Delta X} = \frac{Y_2 - Y_1}{X_2 - X_1}$$

• Steep Upward Slope: A large positive change per unit of time on the stated scale. Acceleration means the slope itself increases, not merely that it is steep.
• Flat Horizontal Line: Zero growth / plateauing performance.
• Downward Slope: Negative trend or declining indicator (e.g., reduction in infant mortality rate).

Inflection Points & Trend Reversals

A turning point changes the direction of a trend, such as from rising to falling. Mathematically, an inflection point changes concavity; it need not reverse the trend. A break in a plotted trend may prompt investigation, but the graph alone cannot establish that a policy or economic event caused it.

---

Pie Charts & Proportional Calculations

Pie charts display how a single total quantity is divided among mutually exclusive categories. The entire circle represents 100%, or $360^\circ$ of central angle.

Mathematical Conversion Rules

To convert between percentage share, central angle degrees, and absolute peso values:

1. Percentage to Degrees:

   $$\text{Degrees} = \text{Percentage number} \times 3.6^\circ$$

   (Example: $25 \times 3.6^\circ = 90^\circ$, equivalently $0.25 \times 360^\circ = 90^\circ$ right angle)

2. Degrees to Percentage:

   $$\text{Percentage} = \frac{\text{Central Angle Degrees}}{360^\circ} \times 100\%$$

3. Sector Value from Total Budget:

   $$\text{Sector Absolute Value} = \left( \frac{\text{Central Angle Degrees}}{360^\circ} \right) \times \text{Total Budget}$$

---

Dual-Axis & Combination Charts

Dual-axis charts feature two different vertical Y-axes sharing a single horizontal X-axis:

• Primary Y-Axis (Left): Usually displays absolute quantities (e.g., Revenue in Billions of PHP as bar elements).
• Secondary Y-Axis (Right): Displays percentage rates or secondary metrics (e.g., Year-on-Year Growth Rate as a line overlay).

Critical Rule: When reading a data point on a dual-axis chart, determine whether the series corresponds to the left or right axis label before reading values.

---

Detecting Graphical Distortions & Manipulation

Executive leaders must remain vigilant against common visual manipulation techniques in reporting:

1. Truncated Y-Axis (Zero-Suppression Trap): Starting the vertical axis at a non-zero baseline (e.g., between 85 and 100 instead of 0) visually exaggerates minor 2% variations into apparent massive spikes or collapses.
2. 3D Perspective Skewing: 3D pie or bar charts tilt the visual plane, making foreground slices or bars appear disproportionately larger than background elements of identical value.
3. Unequal Axis Scaling & Non-Linear Increments: Spacing axis tick marks unevenly to smooth out volatile downward dips or artificially steepen growth lines.
4. Selective Time Horizons (Cherry-Picking): Restricting line graph timeframes to a short anomalous window to hide long-term historical declines or cyclical patterns.

---

Step-by-Step Worked Graphical Problems

Problem: Pie Chart Sector Value Calculation

In this hypothetical budget exercise, a public-sector report presents a ₱5.76 trillion total using a pie chart. The figures are supplied for calculation practice and are not attributed to an official budget publication. The sector for Social Services subtends a central angle of $135^\circ$, while Economic Services subtends $108^\circ$.

Questions:

1. What percentage of the total budget is allocated to Social Services?
2. What is the absolute peso allocation for Economic Services?

Solution:

1. Social Services Percentage Share:

   $$\text{Percentage} = \frac{135^\circ}{360^\circ} \times 100\% = 0.375 \times 100\% = 37.5\%$$

2. Economic Services Peso Allocation:

   $$\text{Economic Services Share} = \frac{108^\circ}{360^\circ} = 0.300 = 30.0\%$$ $$\text{Peso Allocation} = 30.0\% \times \text{PHP 5.76 Trillion} = 0.30 \times \mathrm{PHP}\,5,760,000,000,000 = \text{PHP 1.728 Trillion (or PHP 1,728 Billion)}$$