How to set a threshold / limit line to a bar chart?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2024 04:37 PM
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.
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2024 01:41 PM
@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.
