Thanks for your feedback.
Want to tell us more? Send us an email to leave your feedback.
Individual cell data can be automatically formatted differently than the data in the rest of the report. Data that is formatted differently calls attention to itself, and makes that data easier to locate for analysis. This conditional formatting is called a threshold, because when a given value in your data reaches a certain point, or threshold, the conditional formatting is applied.
Thresholds are described in detail in Formatting conditional values on a grid: Thresholds.
Because of how graph types display report data, a threshold on a graph report displays background formatting only. This includes a solid color, a gradient color, a pattern, and any other available background effects. Other threshold formatting, such as symbols and text formatting, are not applied to the graph report, but are still displayed on the grid report.
Not all graph types can display thresholds. For example, Area graphs combine all data into a single area object. Since the data is all visually connected into the same area object, thresholds cannot be displayed for specific data points. However, many graph types display a separate series or data marker for each data point, and thus can display thresholds.
The following graph types can display thresholds directly on the series of the graph:
For example, the Bar graph report shown below uses thresholds on the series to highlight when employee satisfaction is above seven or below three for a given survey field.
The following graph types can display thresholds on the data markers that highlight specific data points on the series of the graph:
For example, the graph report shown below is the same report used in the previous example. However, the report shown below uses a Line graph style, and the threshold is applied to the data markers.
Click on New Threshold, and name your new threshold.
Any thresholds that are already defined for this metric are displayed below the toolbar. If you want, you can select any existing threshold to modify, and then skip defining the condition, as described in the next step. An existing threshold must include some type of background formatting such as a solid color, a gradient, or a pattern. The background formatting is the only conditional formatting that is displayed on a graph report.
Define the condition that the value must meet to have the threshold formatting applied. Click the text Click here to start a new qualification. The parts of the condition appear, each of which must be defined:
If you selected an existing threshold in the step above, you do not have to redefine the condition.
Next you define the formatting that you want displayed for values that meet the condition you have defined above.
Select a Background Style from the drop-down list, and then choose the colors to use. For details to format the background, click Help.
To apply a background to a graph report, you must select a Background Style other than Default.
Select the threshold that you formatted, and click the Enable threshold on Graph icon on the toolbar. This applies the background color to the graph when the threshold condition is satisfied.
This icon is available only when you have formatted the background of the selected threshold.
Review the graph report. The thresholds should be displayed for applicable data on the graph report. If you are using one of the graph types that support thresholds, and you do not see thresholds on the graph report, use the steps provided below to display the thresholds:
Thanks for taking the time to give us some feedback.
Why wasn't this helpful? (check all that apply)
Vielen Dank, das Sie sich die Zeit genommen haben, uns Ihr Feedback mitzuteilen.
Warum waren diese Informationen nicht hilfreich? (Zutreffendes bitte auswählen)
Merci de nous avoir accordé un peu de votre temps.
Pourquoi ne vous ont-elles pas été utiles ? (cochez tous les choix applicables)
Grazie per avere dedicato del tempo per fornirci un tuo commento.
Perché non è stato utile? (selezionare tutte le risposte adeguate)
Gracias por dedicar su tiempo a proporcionarnos sus comentarios.
¿Por qué no ha sido útil? (Marque todos los que correspondan)
Obrigado por aproveitar o tempo para nos dar alguns comentários.
Por que isso não foi útil? (marque todas as que se aplicam)
피드백을 위해 시간 내 주셔서 감사합니다.
도움이 되지 않은 이유는 무엇입니까? (해당되는 모든 사항 선택)