I want to color code each bar in a column chart based on the type of data
being charted.

The cells are similar to this:

Project ECN Days Goal Type
1243 C0500097 15 4 ECN
1244 C0500096 14 4 ERN
1245 C0500095 13 4 ECN

the chart consists of "Project" and "ECN" as the X axis with "Days" as a bar
and "Goal" as a line.

The color needs to be set based on the "Type" column.

Right now, I do not have the "Type" column as part of the chart source data.

Does anyone know how to accomplish the color code (index) for each "Days" bar?

Thank you for your assistance.

--
Don