LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
ltanner
 
Posts: n/a
Default Formatting lines between data points in a line chart

I have a simple line chart which graphs data over a 3-year timeframe.
Between each of the years, I would like there to be a gap in the line. In my
previous version of Excel, I was able to do this by choosing "None" for the
formatting of the line between the datapoints. In my current version of
Excel (Excel 2002, XP operating system), if I choose "none" it simply charts
a line between 2 non-contiguous months. For example, if I remove the line
between December 2004 and January 2005, Excel 2002 will simply graph the line
between December 2004 and February 2005.

Anyone have a solution for this problem?

--
ltanner
 
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
how to add data points to a scatter plot with trend line Samantha Charts and Charting in Excel 3 April 3rd 23 04:16 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Newbie to charts question - projecting values between data points 38N90W Excel Discussion (Misc queries) 3 January 6th 05 05:15 AM
How to force continuous lines in line charts wal50 Charts and Charting in Excel 1 December 21st 04 10:43 PM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 09:39 PM


All times are GMT +1. The time now is 07:28 PM.

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

About Us

"It's about Microsoft Excel"