histogram with spec limits

[Liam]

I want to plot a histogram with two vertical lines
representing the spec limits. I've got the histogram
data tabulated with the FREQUENCY function, and each spec
limit set up as a series with just the two endpoints. It
seems like it needs to be an XY chart type (to have the x-
axis be a value instead of a category), but I can't
figure out how to have one series be a column type.
Putting the column series on the primary Y axis and the
spec limit series on the secondary axis seems logical,
but the column series ends up being crowded at the left
edge of the graph, obviously not plotted along the value
axis. Any ideas?

 

[Jon Peltier]

Liam -

Usually when people try this, they get to a point where the chart looks
awful, and they quit and start over. Sometimes, however, ugly is an
appropriate intermediate condition. I have some procedures on these
pages that you could try:

http://peltiertech.com/Excel/Charts/AddLine.html

- Jon