Excel bar chart with conditional formatting based on MoM change %

preview_player
Показать описание
Can conditional formatting be applied to an Excel bar chart based on criteria that does not include the values? Yes it can, and this video shows you how.

In this video I show you how to create an Excel bar chart with conditional formatting based on the month over month change in the values instead of the values themselves. I also show how to create a custom data label that includes the value, the change, and an indicator icon. In the video I am using Excel 365 on Windows 10, and most modern versions of Excel will look very similar. If you like the video, please subscribe to the channel and add a comment below.

Рекомендации по теме
Комментарии
Автор

I love this video; thank you! I am trying to do something similar with an Excel gantt chart so that bars are colored by category (planning, data collection, analysis, reporting) and I started creating columns for all those series but I am a little stuck.

melanieespino