Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trying to graph more than one data entry per row
I am trying to graph records of vegetation management per year along a
railway subdivision. In the past Lotus was used to do this. My problem is that for example in y-axis row, I want a bar that starts and stops in two locations along the x-axis. (therefore if the range of the x-axis was from 0-100 miles, and I have data from 2-6, and again from 50-80, and these two sets of data occur in the same year). |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Trying to graph more than one data entry per row
In a chart with one floating bar, you need two series: one for the floating
bar, and one invisible one to provide a space before the beginning of the bar. With two floating bars and a gap, you need four series, two for the visible bars, one for the gap between the bars, and one to the left of the first bar. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "UMA Engineering" <UMA wrote in message ... I am trying to graph records of vegetation management per year along a railway subdivision. In the past Lotus was used to do this. My problem is that for example in y-axis row, I want a bar that starts and stops in two locations along the x-axis. (therefore if the range of the x-axis was from 0-100 miles, and I have data from 2-6, and again from 50-80, and these two sets of data occur in the same year). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding data table with different data to a graph | Charts and Charting in Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
REPOST: How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Named dynamic ranges, copied worksheets and graph source data | Charts and Charting in Excel |