LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default want a break in line graph

I have a line graph with values for years. Between the years 1998 and 1999
there was a coding change so I don't want the line to connect the points for
those two years. I have selected the second point, right clicked and selected
format data point. In the dialog box under the Patterns tab I select none for
the line options. In Excel 2000 and earlier the line would end at the value
for 1998 and start again with the value for 1999. In Excel 2002 and 2003 the
line is not broken and gets connected from 1998 directly to 2000 skipping
1999. This is not the behavior I want and seems like a bug.
--
CathyO
 
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
bar graph: how do you insert a break in scale (squigglly line)? Zach Charts and Charting in Excel 2 April 24th 23 11:50 AM
How to convert a dotted line to a solid line in a line graph Sharlz Charts and Charting in Excel 1 January 14th 09 04:51 AM
How do I graph data daily as a line graph across a calendar format Glani Charts and Charting in Excel 3 November 23rd 07 09:05 AM
Cluster stacked graph AND line combo graph? [email protected] Charts and Charting in Excel 6 October 14th 06 12:33 AM
Break cell into multiple lines by line break Chia Excel Discussion (Misc queries) 1 August 20th 06 06:37 AM


All times are GMT +1. The time now is 11:48 PM.

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"