클래스: Excel: PivotTables in Depth

전체 클래스 보기

업계 전문가가 강의하는 클래스 23,400개를 수강하세요.

Format cells using color scales

Format cells using color scales

클래스: Excel: PivotTables in Depth

1개월 무료이용 시작 단체용 구매

Format cells using color scales

“

- [Instructor] One useful way to summarize data visually is by using a color scale, which uses a cell's value to determine which fill color to assign to the cell. Unlike rule-based formats that either apply a color or not, the color scale conditional format applies a color from a two or three color gradient. And in this movie, I will show you how to create and apply them. My sample file is 05_04_ColorScale, and you can find it in the chapter five folder of the Exercise files collection. In this workbook, I have a pivot table that summarizes retail and wholesale sales for my different sales regions. And let's say that I want to use the color scale to identify the relative values within the body of the pivot table that is in the values area. To start, I'll click any cell within the values area, and then on the home tab, I'll click conditional formatting and then point to color scales and I can use one of the built-in color scales. I have some three color scales and some two color…

목차