Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Actually there is another way to do this, not particularly pleasant but it
works: =SERIES('Error Bars'!$J$5,'Error Bars'!$A$21:$A$31,('Error Bars'!$F$21:$F$24,'Error Bars'!$J$1,'Error Bars'!$F$26:$F$31),1) In the above series formula the series is plotted as three line segments, one of which is an empty cell outside of the data area. Regards, Shane -- Thanks, Shane Devenshire "Paul" wrote: How do I make a line in an XY graph discontinious. I have it working in one place but not in another. I cannot figure out what makes it work this way. It seems if you leave an empty X value has something to do with it. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combination Line and Bar Graph | Charts and Charting in Excel | |||
How do I set a goal line in a bar graph? | Charts and Charting in Excel | |||
Line graph for cumulative number over time | Charts and Charting in Excel | |||
Line Graph Help | Charts and Charting in Excel | |||
Line Graph Data Recognition | Charts and Charting in Excel |