Excel for Data Analysis and Visualization

Add comparative bars into cells

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

In this lesson you will learn how to use one of the best features of conditional formatting, which is the ability to add bar charts inside cells to make it easier to see which are the big numbers and which are the small numbers.

Sometimes even when you have produced a report, it can be hard to see what it means. So below can you easily tell which is the biggest number in the red box? It will take you a few seconds to compare and find which one is the biggest.

Add comparative bars into cells

This is where Data bars can be so useful. As shown below, now it is much easier to see which are the biggest cells.

Add comparative bars into cells

To see the full course contents click here.

0 of 141 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop