excel - Set specific color for a Legend in a dynamic Pivot Chart -
i have pivot chart data coming power query - sql source. colors in pivot chart follow pattern depending on number of legends. starts light blue (based on theme choice) legend values not static since referencing live data - chart 1 starts <30d , chart 2 >=90d, both light blue confusing.
i aware of macros , tried applying upon opening excel not work if refreshed data changed number of legends in chart. (e.g. chart 2 has 2 legend values) , refreshes weekly.
what i'm looking way bind color specific text - <30d red charts. if there's documentation doesn't include macros best. i've tried finding if (legend = <30d) in macro; spent hours still unsuccessful in doing so.
to same issue, loaded data power query worksheet , not data model. when change color legend , data refreshes, not revert default color scheme.
Comments
Post a Comment