Jesús on 09 Aug 2019 01:19:48
when you have a graph to which you can apply a conditional format the legend stays with the default color, the legend should be put with the colors of the mixed conditional format
- Comments (39)
- Merged Idea (3)
RE: legend color in conditional formatting
Please! I have columns in my table that assign a consistent color to each of our business units. Works great with changing background colors in a matrix, but I would like to apply that column to legend members. Right now, I need to go into a line or bubble chart and manually assign the appropriate colors to each business unit.
RE: legend color in conditional formatting
Please! I have columns in my table that assign a consistent color to each of our business units. Works great with changing background colors in a matrix, but I would like to apply that column to legend members. Right now, I need to go into a line or bubble chart and manually assign the appropriate colors to each business unit.
RE: legend color in conditional formatting
Please! I have columns in my table that assign a consistent color to each of our business units. Works great with changing background colors in a matrix, but I would like to apply that column to legend members. Right now, I need to go into a line or bubble chart and manually assign the appropriate colors to each business unit.
RE: legend color in conditional formatting
Unfortunately, I (and others) are unable to upvote even when signed in. The upvotes shown are likely a drastic under-representation of user feedback, so this upvote system needs to be fixed and basic functionality like this should be added regardless of upvotes.
RE: legend color in conditional formatting
Yes this is really needed! Now the legend and the colors in the visual just don't match.
RE: legend color in conditional formatting
second that for consistant and correct date visualization this is a must
RE: legend color in conditional formatting
I am trying to figure out if there is a way to use conditional formatting to go on the basis of the column, rather than the entirety of the matrix.
For example, when I use the Lowest value to Highest value format, it will compare the values of the whole table, when I’d like the conditional formatting to compare lowest to highest of only the values in columns.
RE: legend color in conditional formatting
but is not yet Microsoft certified....