Dividing a chart with a horizontal line

I have a chart that has 15 vertical items down the side, and measurements
across the bottom.

I want to add a horizontal line to the chart that will separate the first 5
items down the side to group them together to the eye. The same thing with
the second 5 items and third 5 items.

Each of these is a "group" that falls into a category that I want to show on
the chart. The first 5 items down the side fall under the group
"professional", the second 5 items fall under a group called "Manager", etc.

Is there any way to add a horizontal line that will make these appear
together, and off to the right add the word "Professional", etc. to the first
five items of the empty area of the chart?

I'm probably not explaining myself very well. Any help would be appreciated!

Start by looking here
http://peltiertech.com/Excel/Charts/...orzErrBar.html
Then here
http://peltiertech.com/Excel/Charts/...orzSeries.html
and
http://www.andypope.info/charts/averageline.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Betsy" wrote in message
...
I have a chart that has 15 vertical items down the side, and measurements
across the bottom.

I want to add a horizontal line to the chart that will separate the first
5
items down the side to group them together to the eye. The same thing
with
the second 5 items and third 5 items.

Each of these is a "group" that falls into a category that I want to show
on
the chart. The first 5 items down the side fall under the group
"professional", the second 5 items fall under a group called "Manager",
etc.

Is there any way to add a horizontal line that will make these appear
together, and off to the right add the word "Professional", etc. to the
first
five items of the empty area of the chart?

I'm probably not explaining myself very well. Any help would be
appreciated!

Thank you, Bernard! I think this is working!!

"Bernard Liengme" wrote:

Start by looking here
http://peltiertech.com/Excel/Charts/...orzErrBar.html
Then here
http://peltiertech.com/Excel/Charts/...orzSeries.html
and
http://www.andypope.info/charts/averageline.htm
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Betsy" wrote in message
...
I have a chart that has 15 vertical items down the side, and measurements
across the bottom.

I want to add a horizontal line to the chart that will separate the first
5
items down the side to group them together to the eye. The same thing
with
the second 5 items and third 5 items.

Each of these is a "group" that falls into a category that I want to show
on
the chart. The first 5 items down the side fall under the group
"professional", the second 5 items fall under a group called "Manager",
etc.

Is there any way to add a horizontal line that will make these appear
together, and off to the right add the word "Professional", etc. to the
first
five items of the empty area of the chart?

I'm probably not explaining myself very well. Any help would be
appreciated!