Here's what I've got in my chart now:
I'd like only the bottom part showing the different from year's average to be colored with the red and green indicators and the top part showing average total for the week to be one, single solid color. Any idea how to do this?
Figured it out...for those having trouble, You need to select the correct mark (in my case avg(Total)) and remove the color from the shelf. That'll do it.
Retrieving data ...