| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
plot range bar chart
How do I plot a range in a bar chart? I would like to list names on one axis
and years on the other. Then I want to plot their years of service. For example: If John Doe served from 2005 - 2007, I want the chart to show that range, but not before or after. Below John I have Jane Doe who served from 2001-2006. The chart, then would have an overall range of 2001-2007. Maybe a bar chart isn't the correct one (it will only "start" data at the starting point - 2001). |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
plot range bar chart
Hi,
You should be able to use the techniques used to build a gantt chart. http://pubs.logicalexpressions.com/P...cle.asp?ID=343 Cheers Andy kh wrote: How do I plot a range in a bar chart? I would like to list names on one axis and years on the other. Then I want to plot their years of service. For example: If John Doe served from 2005 - 2007, I want the chart to show that range, but not before or after. Below John I have Jane Doe who served from 2001-2006. The chart, then would have an overall range of 2001-2007. Maybe a bar chart isn't the correct one (it will only "start" data at the starting point - 2001). -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| plot range in excel chart | Excel Discussion (Misc queries) | |||
| Removing Plot lines between plot points on a line chart | Charts and Charting in Excel | |||
| how to plot a polar chart / plot | Charts and Charting in Excel | |||
| Excel chart : I want to plot on the same chart bar and line | Charts and Charting in Excel | |||
| ExceL Options: Add a chart for Box-plot type and Range function | Excel Discussion (Misc queries) | |||
Linear Mode
