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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"calvin" wrote in message
...
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.