how to link legend icon color automatically to data color?

ZHANG Huan 0 Reputation points
2023-05-26T02:37:52.29+00:00

Background:

  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.

2023-05-26_10h00_09

Problem:

  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!

BR

Hanny

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.
3,874 questions
0 comments No comments
{count} votes