MelindaLadd
New Member
Hello-
I have a line chart tied to a pivot chart so the values in the chart change based on slicer selection.
The pivot chart has status icons from conditional formatting.
Is it possible to show the status icon instead of the value in the label?
I know you can add a [red]/[green] type format but the criteria for red/green changes based on what is selected.
I am thinking there may be a way through Custom Format Code in Data Labels formatting?
I have a line chart tied to a pivot chart so the values in the chart change based on slicer selection.
The pivot chart has status icons from conditional formatting.
Is it possible to show the status icon instead of the value in the label?
I know you can add a [red]/[green] type format but the criteria for red/green changes based on what is selected.
I am thinking there may be a way through Custom Format Code in Data Labels formatting?