how to link legend icon color automatically to data color?

ZHANG Huan 0 Reputation points


  1. We'd to compare year-to-date(YTD) data VS forecast(CF). target achieved -> green color, otherwise Red.
  2. we use formula to make bar color update based on above logic.



  1. legend color (circled in blue in above pic) can not be automatically updated based on bar color. or it doesn't know how because there're 2 colors

Question: How can i make legend color and YTD color sync? is there any better visual to be applied?

Many thanks in advance!



Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
1,118 questions
0 comments No comments
{count} votes