Charts Lesson 4: Sparklines and In-Cell Charts
Put tiny charts inside cells: line, column and win/loss sparklines, high/low markers, data bars and REPT bars — perfect for tables and dashboards.
Read article →Charts & Dashboards
Charts and dashboards that update themselves.
Charts Lesson 3: Combo Charts — Actual vs Target
Charts Lesson 3: Combo Charts — Actual vs Target
Show actual against target in one chart: column + line combo, secondary axis for percentages, target as a marker line, and highlighting months below…
Read article →Charts Lesson 2: Column, Bar and Line Charts Done Properly
Charts Lesson 2: Column, Bar and Line Charts Done Properly
Build clean column, bar and line charts in Excel: select data, insert, sort, gap width, data labels, axis formatting, removing clutter and saving a…
Read article →Charts Lesson 1: Choosing the Right Chart
Charts Lesson 1: Choosing the Right Chart
Match the chart to the question: comparison, trend, composition, relationship and distribution, with the charts that work and the ones that mislead.
Read article →Build a Monthly MIS Report in Excel From Scratch (Complete Guide)
Build a Monthly MIS Report in Excel From Scratch (Complete Guide)
A complete, reusable monthly MIS workbook: raw data sheets, a mapping table, SUMIFS-driven P&L and KPI pages, variance vs budget and last year, conditional…
Read article →In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
In-Cell Bar Charts in Excel: REPT, Data Bars and Sparklines
Three ways to show charts inside cells — the REPT formula trick, conditional-formatting Data Bars and Sparklines — for compact dashboards that update automatically.
Read article →Power BI Desktop: Build Your First Report From an Excel File
Power BI Desktop: Build Your First Report From an Excel File
Step-by-step first Power BI report from an Excel table: install, Get data, check types in Power Query, build cards, bar and line charts, a…
Read article →