mad3654
asked on
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.
Based on source data for Upper Limit and Lower Limit.
|
_|_|___________ Upper limit
| |
_|_|___________ Lower Limit
| |
Something like this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
We're cleaning up the topic areas and need all the help we can get.
Thanks!
amp
Community Support Moderator
ASKER
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.
-Craig