Hi,

This is my first post to this forum so hopefully it goes well Basically, I have a column chart that charts several projects' dollar values. As of now, the color of every column is the same. I want to bring in the values from a different excel column, but within the same table as the project and dollar value, called source (which is basically just binary-- can only be "SS" or "C"). See below for simple layout of the data:

A B C
| Project Name | $ Value | Source
1 | Project XYZ | $5,000 | SS
2 | Project ABC | $15,000 | C
3 | Project HIJ | $2,000 | C
4 | Project EFG | $14,000 | SS
.
.

But, rather than bring in this as another series plotted on the chart as a line graph, etc., I would like the color of the "dollar value" columns in the chart to change based on whether the source is "SS" or a "C." (i.e. row 1 above would have a $5,000 purple column for "Project XYZ" in the graph, and row 2 would have a $15,000 yellow column for "Project ABC"-- meaning all projects with an "SS" source would have a purple dollar value column, and a yellow one for those with a source of "C.")

Any help on this would be greatly appreciated!