How to set a threshold / limit line to a bar chart?

KdP_300 — Thu, 25 Jul 2024 23:37:46 GMT

How can I set a fixed limit (threshold) line to a bar graph? (Not a trendline). I want to monitor anything that exceeds the limit/threshold.

Re: How to set a threshold / limit line to a bar chart?

JoeM — Thu, 01 Aug 2024 20:41:21 GMT

@KdP_300

There are two options -
1) Add a plot band under the formatting. Here, you could draw a large plot around the expected range or create a thin plot that appears as a line.
2) While this isn't precisely what you asked for, you could use conditional formatting to highlight any columns that exceed a specific value.

topic Re: How to set a threshold / limit line to a bar chart? in Dashboards & Analytics Discussions

How to set a threshold / limit line to a bar chart?

Re: How to set a threshold / limit line to a bar chart?