Creating Bar Chart with "Acceptable Range"

[sighlent1]

Hey,

For work, I'm doing a project for Quality Control. I'm looking to create a Bar Chart (horizontal bars) with 2 "vertical" lines to indicate the range of acceptable values

Attached to this Post is a *.pdf that (hopefully) further explains what I'm looking for. If somebody could send me a chart in excel that looks like this, i would highly appreciate it

Thank you soooo much for your time
Bob

[Mike_S]

Hi, Mocked up an example of what I think you need. I have xl2007 so hope formatting etc comes through. It will need some tidying up but hopefully it will help. Regards, Mike

[Andy Pope]

You can plot the 2 series as xy-scatter.

[sighlent1]

This looks GREAT!!! Thank you sooo much

If I want to add in another set of data (another 2,3, or 4 columns of Values) for the Bar Chart, how do I do that? I tried editing & formatting the chart, but easier said than done.

Thank you,
Bob

[sighlent1]

ohhhhh, i JUST figured out how to add more bars

Thank you again, and have a GREAT New Years!!!
Bob