Hoping this is an easy one. I like to use the Square marks with colors to spice up a text table. In this particular case, I will probably only end up showing the "Average" column and hide the individual year columns, but why won't the color apply to that Average column? Before I go back to my Excel file and just create a new variable, figured I'd check here first. Many thanks!
Easy to do. Edit your color shelf, then select "Include Totals".