Carlos asks how to have the smallest number have the largest data bar in Microsoft Excel.

Microsoft Excel Conditional Formatting offers three data visualization tools. Two of them are easily reversible. But Data Bars don’t have an easy way to reverse.

Nancy Faust takes us into the “Danger Zone” as I try using a devious number format to mask negative numbers as positive numbers.

Table of Contents
(0:00) Small Number Long Data Bar
(0:14) Reversing Color Bar in Excel
(0:24) Reversing Icon Sets in Excel
(0:42) Data Bar outside cell
(1:08) Negative Values Data Bar setting
(1:24) Show Bar Only in Data Bars
(1:34) Danger Zone: Devious Number Format
(2:14) Showing Negative numbers as positive in Excel
(2:45) Wrap-up