View Single Post
  #4   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

Have you thought of using a stacked chart with vertical separation?

http://www.peltiertech.com/Excel/Cha...s.html#StakCht

"SWeyer" wrote in message
...
Thanks for the suggestion. Unfortunately, this will not work for me, as I
have a chart that displays five columns (I mispoke before I am using a

column
chart, not a bar chart) for each month. The idea is to track the

performance
in each of the 5 categories across the year.

"Barb Reinhardt" wrote:

Add a series for the max and a series for the min. Change the chart

type
for each series to LINE and change the point display as needed.

"SWeyer" wrote in message
...
Hello all. I am constructing bar graph to display the numerical

results
of
our quality metrics, and my boss would like the maximun and the

mininum
displayed for each category as dots over and in the individual bars.

I
know
I can add error bars, but is there any way to do it as a simple dot

and
not
have the lines? I hope that makes sense.