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 Removing Plot lines between plot points on a line chart

Hi,

Should work. If you just want to hide the line between to points but leave
the others visible:

1. Click the series
2. Click the data point on the right end of the line you want to remove
3. Choose Chart Tools, Format, Format Selection, Line Color, No Line

You can apply this to all the line in a series by skipping step 2.
--
Cheers,
Shane Devenshire


"JDKapono24" wrote:

A 2003 file being opened in 2007. Contains a line graph. I wish to remove a
plot line between two points. The lines right now or dotted, when I go
through the process of entering into the chart options and click on "No plot
line" nothing happens and the dotted lines remain. ANy suggestions? Or is
this a converting issue going from 2003 to 2007?

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
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
How to add a line plot onto a stacked plot in Excel Vijay Charts and Charting in Excel 1 November 14th 07 01:04 PM
Plot points on a chart and record the coordinates Mr. Rodgers[_2_] Charts and Charting in Excel 1 April 30th 07 06:39 PM
automatically plot points on chart QuantumLeap Charts and Charting in Excel 4 March 21st 06 10:58 PM
Plot order of lines and points in XY scatterplots Elizabeth Charts and Charting in Excel 2 February 1st 06 09:44 PM


All times are GMT +1. The time now is 10:30 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"