Actually, I think this one fits the latest description:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Barb Reinhardt wrote:

If you want to stay with a bar chart, try this:

http://www.peltiertech.com/Excel/Cha...LineCombo.html

"SWeyer" wrote in message
...

Yes, but it requires too much formatting. My boss wants something she can
keep and enter data into on a month by month basis and have it

automatically

spit out a graph. I have already set this up for her previously, she's

just

seeing if I can add another set of bells and whistles. But I've come to

the

conclusion she can't have all the data on one graph and have it make any
sense. She seems fine with this, thank heavens :) Thanks for all your

help!

"Barb Reinhardt" wrote:


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.