Skip to content
  • Home
  • About
  • All posts
  • Contact
  • Ask a question
  • Home
  • About
  • All posts
  • Contact
  • Ask a question
Login to online classes
  • Start Here
  • Blog
  • Classes
    • Excel School
    • VBA Classes – Learn VBA Macros today
    • Power BI Play Date
    • 50 Ways to Analyze your Data
    • Mini-Courses
    • Power BI Remote Training Options
  • Videos
    • Intro to Excel
    • Writing Formulas
    • … more
  • Topics
    • Excel Basics
    • Advanced Excel Skills
    • Learn Power BI
    • Power Query Tutorial
    • Excel Pivot Tables – Full guide
    • Project Management using Excel
  • Formulas
    • Tables & Structural Refs
    • IF
    • CHOOSE
    • XLOOKUP
    • SUMIFS
    • SUBTOTAL
    • INDEX
    • VLOOKUP & other lookups
    • 100+ Formula Examples
    • Multi-condition lookups
    • Array formulas
    • Top 10 formulas
  • Dashboards
    • What are they, how to make one?
    • Dynamic Dashboard in Excel
    • Customer Service Dashboard
    • 200+ Examples
    • Dashboard Training Course
  • Charts
  • VBA
    • 40+ Examples
    • More on VBA
  • Resources
    • 100s of FREE Excel Templates
    • Resources for Freelancers
    • Mini-Courses
  • Start Here
  • Blog
  • Classes
    • Excel School
    • VBA Classes – Learn VBA Macros today
    • Power BI Play Date
    • 50 Ways to Analyze your Data
    • Mini-Courses
    • Power BI Remote Training Options
  • Videos
    • Intro to Excel
    • Writing Formulas
    • … more
  • Topics
    • Excel Basics
    • Advanced Excel Skills
    • Learn Power BI
    • Power Query Tutorial
    • Excel Pivot Tables – Full guide
    • Project Management using Excel
  • Formulas
    • Tables & Structural Refs
    • IF
    • CHOOSE
    • XLOOKUP
    • SUMIFS
    • SUBTOTAL
    • INDEX
    • VLOOKUP & other lookups
    • 100+ Formula Examples
    • Multi-condition lookups
    • Array formulas
    • Top 10 formulas
  • Dashboards
    • What are they, how to make one?
    • Dynamic Dashboard in Excel
    • Customer Service Dashboard
    • 200+ Examples
    • Dashboard Training Course
  • Charts
  • VBA
    • 40+ Examples
    • More on VBA
  • Resources
    • 100s of FREE Excel Templates
    • Resources for Freelancers
    • Mini-Courses

Tag: broken y axis

Cropped chart: when some values are too big to fit

We know that column charts are excellent for presenting information. But what if some of the columns are too tall and hijacking the rest. In a previous article, we discussed few of the approaches. Today let’s learn how to build a cropped chart (broken y-axis chart) using Excel, something like above.

Looks interesting? Read on.

Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free. 

Yes, sign me up

Get Started

  • Excel Basics
  • Advanced Excel
  • 100+ Formulas
  • Free Crash Course
  • Pivot Tables
  • Power BI

Online Classes

  • Excel School
  • VBA Classes
  • Power BI Classes
  • 50 ways to analyze data
  • Mini Courses

About

  • My Story
  • Welcome Message
  • Contact
  • Forum & Community

Downloads

  • 20+ Excel Templates
  • 200+ Dashboards
  • 40+ VBA Code samples
  • Ebooks & More
Twitter Facebook-f Youtube Linkedin-in

© All rights reserved.