The ‘Result’ column can mean income, expenditure, or anything else we would like. In column ‘Period,’ we see those days’ results will be analyzed. It is true that here only two can be seen, but we indeed need four of them. We will create a four-part conditional color chart based on the data seen in the above picture. Conditional Color Chart – Calculated Fields For example, notice that the sixth data point from the left has changed! (It’s value stayed: 39). However average has changed, and data points have been colored according to this fact. At first glance, everything seems unchanged, and it is true to some degree because values haven’t been altered. The animation shows how the display will change if we change the value of the ‘Target’ (average) field. Thus, below average is represented by red, and above average is green. We will compare to this the points of daily values and differences. We have represented the average by a blue broken line. You will use it more in the future because it is a lot better to see things in dynamics than static. On the animation below can be seen the essence of this data visualization. Unfortunately, Excel doesn’t support this method, but there is a solution for displaying values different from the average (in the positive or negative direction). Today’s presentation aims to display values by assigning color codes in connection with larger or smaller than a given parameter (average). What is this all about? When we color or assign distinctive signs to the cells, then we are talking about conditional formatting. However, with a little thinking, we can easily make a spectacular Excel chart template also. So far, we could mostly have the opportunity to use conditional formatting in Excel with cells. Today’s article will help us in the solution of a very rare but important issue. The conditional color chart is an interesting experiment for extending the Excel toolbox.