How do we apply conditional formatting for a pivot chart. i have a pivot chart with two column bars where one bar color should change to red if number is less than the other bar number and vice versa.
Thank You
How do we apply conditional formatting for a pivot chart. i have a pivot chart with two column bars where one bar color should change to red if number is less than the other bar number and vice versa.
Thank You
Hi,
Welcome to the Forum.
I don't think you can change the color of a column bar against the adjacent bars by applying a formula, however, you have the option to change color by using "Invert if Negative". With this you can set a different color for all negative values in the graph.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks