Vertical line in a histogram (vertical bar chart)

G

Guest

I have a dynamic hystogram chart that keeps track of current process
performance. So it is always changing as new data is entered.
I would like to have a vertical line indicating the average. (And if I get
that figured out I would add more vertical lines representing UCL and LCL
control limits)
I have tried methods using a secondary axis and error bars, but they don't
quite work because the scale for the secondary category axis and the primary
category axis are not the same, so the line is in the wrong place.
I could set the scales equal manually, but that doesn't quite work for me
because the charts are always changing and I need the scales to move
automatically.
Any help on this would be awesome.
Thanks so much!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top