Excel column chart with increase and decrease columns - dynamic ranges - by Chris Menard

Need to see decreases in an Excel chart in a different color from increases or the previous month? I use two helper columns in Excel with an IF statement. I use an Excel Recommend Chart to make the column chart. For example, columns are in a blue fill color if sales increased from the previous month, but a month that has a decrease has a red fill color.

In cell C3, I used the function shown in this screenshot.

In cell D3, I used the same function, but I changed the arguments. The second argument is blank, and the third argument is cell B3.

#excel #msexcel #microsoftexcel

Chris Menard's training website:

column chart,microsoft excel,excel tutorial,column chart in excel,column chart two colors,column chart decrease,excel dynamic chart,excel show changes in red,