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! |
Dividing a chart with a horizontal line
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! |
Dividing a chart with a horizontal line
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! |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com