Change chart colors corresponding to cell color

**mmenshawy2** · 09-23-2019, 06:13 AM

Is it possible to change chart color in correspondence to cell color
For eg if cell is green i need the part in chart represents it to be green as well

**KOKOSEK** · 09-23-2019, 06:45 AM

With such limited information I can only say that probably yes.

**mmenshawy2** · 09-23-2019, 07:33 AM

Originally Posted by KOKOSEK

With such limited information I can only say that probably yes.

Can you tell me how

**KOKOSEK** · 09-23-2019, 07:48 AM

It is possible by VBA. Check color of cell which is data of series and then apply it into series on chart.
Could you attached sample file, please? Describe inside what do You need and then we will try to help You.
Check attached file. Each calculation generates random colors for cells (which are data for chart) then based on these colors colouring columns on chart.