View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

Why did they ever break that feature??

Could you use an XY Scatter chart? This still works as expected. If the
category labels have to be text labels (a scatter chart will replace
these with 1, 2, 3, etc.), make a chart with two series, the first
having zero for its Y values, the second being this unruly line series.
Make it as a column chart, to get the text labels, then select the
second, and using Chart Type form the Chart menu, change it to a Scatter
series. Then select and format the line segment you want to hide.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

ltanner wrote:

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?