C
Cexcel
Hello,
I have a pivot table showing this data:
A summary of errors grouped by week.
Errors- Week1 Week2 Week3
name1 30 23 15
name2 2 1 2
name3 25 1 2
name4 3 13 2
name5 6 5 54
name6 1 0 1
I would have about 50+ names and I wanted to show which names have a trend of high errors all the time.
I used the databars under conditional formatting and it looks OK but looks too crowded. I wonder if there is a better way to show this.
in this case, a trend of high errors will be Name1 as it seems that is consistent with many errors week to week. I would like to highlight that. Name5 made a lot of errors on week 3 but for most part is good. I would highlight in a different color.
Any ideas will be really great. thanks
I have a pivot table showing this data:
A summary of errors grouped by week.
Errors- Week1 Week2 Week3
name1 30 23 15
name2 2 1 2
name3 25 1 2
name4 3 13 2
name5 6 5 54
name6 1 0 1
I would have about 50+ names and I wanted to show which names have a trend of high errors all the time.
I used the databars under conditional formatting and it looks OK but looks too crowded. I wonder if there is a better way to show this.
in this case, a trend of high errors will be Name1 as it seems that is consistent with many errors week to week. I would like to highlight that. Name5 made a lot of errors on week 3 but for most part is good. I would highlight in a different color.
Any ideas will be really great. thanks