Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,344
Default Discontinious Line in XY Graph

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination Line and Bar Graph M Moore Charts and Charting in Excel 1 September 1st 06 09:13 AM
How do I set a goal line in a bar graph? mtwelsh72 Charts and Charting in Excel 3 April 14th 06 05:55 PM
Line graph for cumulative number over time Jane Charts and Charting in Excel 0 April 9th 06 07:19 AM
Line Graph Help mickeymouse Charts and Charting in Excel 2 January 27th 06 08:39 AM
Line Graph Data Recognition Nat Charts and Charting in Excel 2 April 30th 05 02:07 PM


All times are GMT +1. The time now is 01:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"