EXCEL CHARTS AND GRAPHS NINJA The Best and Fastest Program to Become a Master Using Charts and Graphs in Microsoft Excel (Mejia, Henry E.) (Z-Library)

# EXCEL CHARTS AND GRAPHS NINJA — Reading Guide ## 【One-Line Pitch】 A fast, exercise-driven handbook that teaches you to choose and build the right Excel chart for the story your data is telling—ideal for business professionals, analysts, and anyone who presents data regularly and wants to move beyond default chart choices. ## 【Book Arc】 - **Opening (~0%–12%)**: Introduces the Excel Ninja Series philosophy (fast, practice-based, no filler), explains what a chart truly is—a visual tool to TELL A STORY—and previews the chart types covered. Establishes the core question you must ask before charting: "What do I need to convey?" - **Early (~12%–28%)**: Chapter 3 gives a general overview of chart categories (development over time, proportion of a whole, relationship between variables, distribution of data) and introduces each major chart type. The book then dives deep into Bar Charts (Chapter 4), covering when to use them, when to avoid them, and hands-on exercises with superhero-themed revenue data. - **Middle (~28%–44%)**: Continues Bar Chart mastery with multi-variable comparisons (Clustered Column), Stacked Charts, and 100% Stacked Charts—showing how each variant tells a different story about the same data. Includes step-by-step exercise walkthroughs with practice files. - **Middle (~44%–52%)**: Moves to Pie Charts (Chapter 5), covering simple pies, Doughnut charts, Pie of Pie, and Bar of Pie variants. Emphasizes when proportions matter most and how to handle subcategories without cluttering the visual. - **Late (~52%–100%)**: Covers Line Charts (Chapter 6), Area Charts (Chapter 7), Treemap (Chapter 8), Waterfall/Bridge (Chapter 9), Scatterplot (Chapter 10), and Histogram (Chapter 11), followed by quick final tips. Each chapter follows the same pattern: use cases, avoid cases, and practice exercises. ## 【Key Takeaways】 - **Charts exist to tell a story, not decorate a report** (Early): Before creating any chart, ask "What do I need to convey?"—the answer determines which chart type is correct. This framing prevents the common mistake of picking a chart because it looks nice rather than because it communicates effectively. - **Bar Charts are the workhorse but have clear limits** (Early): Excellent for showing one variable over time or comparing multiple variables at a point in time, but they fail at proportions, distributions, and showing intermediate steps. Keep them simple—too much information creates visual clutter. - **Pie Charts are for proportions only** (Middle): Use them when you need to show parts of a whole with a single variable and fewer than 10 categories. Never use them for time development or distribution. The requirement that all slices sum to 100% is non-negotiable for accuracy. - **Doughnut vs. Pie is a storytelling choice** (Middle): If the total amount matters more than the individual pieces, use a Doughnut chart and insert the total in the center. If the pieces and percentages are the story, stick with a standard Pie. - **Pie of Pie and Bar of Pie solve the subcategory problem** (Middle): When one slice needs breakdown (like R&D split into sub-departments), these variants show the main pie plus a secondary plot. The "Values in second plot" setting controls how many items appear in the secondary visualization. - **Line Charts excel at multi-variable trends** (Late): Unlike Bar Charts, Line Charts can track several variables over time simultaneously. However, stacked line variants are confusing and should be avoided—Area Charts handle that need better. - **Chart selection is about matching story to structure** (Early): The book categorizes what you want to convey into four buckets—development over time, proportion of a whole, relationship between variables, and distribution of data—and each chart type maps to specific buckets. ## 【Reading Tips】 1. **Download the 26 practice spreadsheets first**—the book's entire method is "learn by doing," and each chapter references specific exercise files (e.g., Chapter4ex1.xlsx). Reading without doing will cut the value significantly. 2. **Skim Chapter 3 (chart overview) if you're experienced**, but don't skip it entirely—it establishes the decision framework (what story are you telling?) that the rest of the book builds on. 3. **Deep-read the "SITUATIONS TO USE" and "SITUATIONS TO AVOID" lists** in each chart chapter. These are the most practical, reusable takeaways and are formatted for quick reference later. 4. **Pay special attention to the Stacked vs. 100% Stacked distinction** in the Bar and Area chart chapters—these variants look similar but tell fundamentally different stories (absolute totals vs. percentage contribution). 5. **The superhero-themed exercises are intentionally playful**—don't let the fun data distract you from the underlying logic. The scenarios (revenue by store, spending by department) map directly to real business situations. ## 【Coverage Limits】 Excerpts cover Bar Charts and Pie Charts in depth, with partial coverage of Line Charts. The later chapters (Area, Treemap, Waterfall, Scatterplot, Histogram) are listed in the table of contents but their detailed content is not fully represented in the available excerpts. ##