Celeb Glow
general | March 06, 2026

Can you make it so a chart color gradient color changes with a cell value?

I am curious if it is possible to make a two colored gradient bubble to have its colors dependent on cell values / colors.

I have a bubble graph where I want to have each bubble two different colors via a gradient. Each half of the bubble color is dependent on the color of a cell. It would make for less errors if the colors of the bubbles were autofilled based off the color in two cells.

Is something like this possible to do?

Bubble graph photo

5 Reset to default

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy