Excel 2019: Build Numbered & Dual-Axis Charts

Course description

This course explores how to present numerical data in Excel 2019 charts with precision, clarity, and balance, focusing on formatting details and comparison techniques such as dual-axis charts. You'll learn how to control numeric presentation so charts convey accurate meaning without unnecessary complexity. Topics include customizing axis values, applying display units, removing distracting decimals, and choosing appropriate number formats such as Currency or Accounting to match reporting standards. The course also explains how to display symbols, manage tick marks, and adjust label positioning for readability while maintaining a professional appearance. You'll examine the relationship between data scale and perception, learning how to avoid visual distortion when working with very large or very small figures. The focus then shifts to dual-axis charts, which help visualize related metrics with different magnitudes on the same chart. You'll see how to assign a metric to a secondary axis, select compatible chart types, and align scales so each series remains legible and proportional. The course highlights common pitfalls such as mismatched axes or misleading comparisons and demonstrates best practices for creating accessible, honest visuals. Additional sections cover reformatting charts, selecting appropriate bounds and intervals, and determining when multiple axes enhance understanding versus clutter interpretation. By the end, you'll know how to build charts that accurately express quantitative relationships for dashboards, reports, and presentations.

Course outline