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.

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.

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.

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.

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.

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.

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.