• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2879
  • Last Modified:

Upper limits and Lower limits

Is there a way to set an Upper and Lower limit to show a line on a chart.  I want to show where a value should be vs the the bar chart.
Based on source data for Upper Limit and Lower Limit.

 |
_|_|___________ Upper limit

 | |
_|_|___________ Lower Limit
 | |

Something like this.
0
mad3654
Asked:
mad3654
1 Solution
 
GudareCommented:
Use additional series and manually set your values to the same value across the values area. You'll need to put in a value for each category. Holler if you need more explicit info, I'll put something up later, bit busy atm. :)

-Craig
0
 
skillswCommented:
Hi,

Try this with error bars.

Harsha
0
 
amp072397Commented:
Can we get some feedback here?

We're cleaning up the topic areas and need all the help we can get.

Thanks!
amp
Community Support Moderator
0
 
mad3654Author Commented:
I put data to creat bars for the upper and lower limits and showed the data values on the chart.  Then hid the bars by eliminating the bar area color and no border color.  Then I did an over lap so the data values are on top of the data bars for for my chart.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now