Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add a vertical line to a horizontal bar chart? | Charts and Charting in Excel | |||
Add horizontal line to a chart | Charts and Charting in Excel | |||
Add line to horizontal bar chart | Charts and Charting in Excel | |||
Horizontal Line Chart | Charts and Charting in Excel | |||
chart displaying horizontal line for zero data | New Users to Excel |