I need to create with Microsoft Excel, a column graph that based on different values, each column will contain different color.

To be precise:

E.g.:

- Green: If it is 0

- Orange: If it is between 0 and 10

- Red: If it is more than 10

I would appreciate to help me how to do this.

Hi EriValidata,

According to your description, I get the result as shown in the following figure.

Is this a correct result? If yes, this is an excel chart with conditional formatting. Please try the following steps to create the chart.

To accomplish this task, you will need to create three additional columns of data and plot those three columns of data-and not the original column of sales data in a stacked column chart. As shown in the figure.

And the formula in C2 is: =IF(AND(B2>0,B2<=10),B2,0). The formula shows the value in column C if it falls between the limits in rows 0 and 10; otherwise it shows 0. The formula is filled into the range C2:E4.

Then we select the source data with A2:A4 and C1:E4, as shown in the figure to insert a column chart. The chart now shows 3 sets of colored bars, one for each data range of interest.

And I upload a TEST2.xlsx file on OneDrive, you can download this file via this link:

https://microsoft-my.sharepoint.com/personal/v-lzng_microsoft_com/Documents/Shared with Everyone

Hope its helpful.

Regards,

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator 5 hours 52 minutes ago