Type different values into the Value 1 and Value 2 boxes to create custom ranges. The Color assignments list shows a list of possible value ranges and assigns a fill color and text color to each range. Select Each color represents a range of values to use a range of colors, from bright to muted, to indicate a range of values. To select a different fill or text color, click the Fill Color or Text Color arrow. The Color assignments list shows all the available values and assigns a fill color and text color to each value. Select Each color represents a unique value to apply the same color to all shapes that have the same value.
Under Coloring method, do one of the following: In the New Color by Value dialog box, under Display, select an item from the Data field list. In the Edit Data Graphic dialog box, click New Item, and then click Color by Value. In the Data Graphics task pane, right-click the data graphic that you want to color code, and then click Edit Data Graphic on the shortcut menu. On the Data menu, click Display Data on Shapes. For more information about the Data Graphics feature, see Enhance your data with data graphics. With the Color by Value option of the Data Graphics feature, you can apply color to indicate unique values or ranges of values. If you want to remove any coloring assignments, click Delete on the right. If you want to add any additional coloring assignments, click Insert on the right, type new values, and choose colors for those value. If you want to correct any of the values, you can do so in the Value columns. If you also want the shape text to get changed, select a Text Color. Choose a Fill color for each of the ranges. The bottom of the range is specified by Value 1 and the top is Value 2. If you chose this option:, you’ll see that each fill color has a range. If you chose this option:, then choose a Fill Color for each of the possible values in your imported data. In the above process, if you chose a field with numbers, choose this option.Īfter applying a color, you may need to configure the colors to represent your data properly. This option is for fields that have numeric values like percentages or amounts. In the above process, if you chose a field with text, choose this option. This option is for fields that have text values like “On,” “Off,” “On Track,” “Off Track,” and so on. Under Color by Value, select one of the following: On the Data tab, click the down arrow at the bottom of the Data Graphic gallery. In the same pane, make sure the field you want to change has a check mark, and make sure to select it so that it is highlighted in blue: In the Data Graphic Fields pane, identify which field of data you want to apply coloring to. If you want to change only select shapes on the page, click one or more shapes to select them. If you want to change all shapes on the page, click an empty space on the diagram to deselect any shapes that may be selected. If it isn’t open, on the Data tab, click to select the Data Graphic Fields check box. Make sure the Data Graphic Fields pane is open on the right.