I'm working on the metrics from my team.
I need to show in a line chart only the success rate of the changes.
I have created the table and the pivot chart.
Now, I would like to know how to hide the unsuccessful lines from the chart?? Without filtering the columns from the pivot table.
table_example.xlsx
I have attached a copy of the pivot table and a copy from the the chart. So that is not the actual info.
If you see the chart, I need to hide the "No impact - Backed out" and "No impact - Not backed out" lines from the chart without affecting the success line.
Thanks
Bookmarks