Dynamically change column color in chart

E

Everett

It's been a while since I was in here...
I'm wondering if it's possible to create a column chart
where the color of each column changes according to data in
a separate source range. For example, graph the numbers in
column A, and determine their color using the values in
column B. There are only 2 or 3 different possible colors.
Perhaps a series for each? Thanks for any suggestions.

Out of practice,
Everett
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two-tone color column chart 2
Color change for Column Chart 4
change color of column chart 2
Using VBA to swap between a clustered or separated column chart 4
2D Dynamic Charts 5
to make column letter dynamic in charts 2
create chart with column axis 10
Odd Chart Format Results 1

Top