Negative numbers in a range result in an axis being drawn, and the bar appearing the other side of the axis, in a different color (D). You have full control of colors of the axis and bars. But, wait, there's more. You can control the max and min of the chart - great if you have multiple in-cell bar chart ranges that you want to be able to compare.
You can't have the bars offset from the data as they are a conditional format, but you could just slap in a formula where you want the bar: "=cell where the data is", and then click the option to show just the bar, not the data (E). Even the gradient option is better, as there is a border by default allowing you to see where the end of the bar is (C). Finally, the resolution of the bar (i.e. when a bar height goes to zero), depends on the width of the cell (B). Great job Microsoft.
I haven't managed to figure out if you can color a bar based on its value - i.e. have them all grey, except for bars over 500, which are red.
ReplyDeleteI tried to fake it out with a formula where if it was over 500, make it negative, color negative bars red, then show negative values in the same direction as positive, but no bar appeared - my first beta bug?