chart with tolerences

[calvin]

Need a sheet to have input for limits and then be able to show the values on
a chart. would like to show the value inside a bar that represents the limits.

 

[Jon Peltier]

Arrange your data in this order:

Category Labels (first column)
Minimum Limit
Values
Maximum Limit (last column)

Make a line chart with this data. Format any of the line series to add
up-down bars, which means draw a bar from the first line series (minimum
limit) to the last (maximum limit). Format the minimum and maximum limit
series with no lines and no markers to hide them.

- Jon