Programming a Chart

Can you “program” the colors and patterns when you create charts rather than hand making each one

I wonder if it’s possible to code the color per journalist in this example

Can I add a column in Excel that will allow me to code each journalist rather than manually in the chart column?

https://www.dropbox.com/t/Zcl4vaSR3oGHbC5s